topic Data Reduction & Circular Reference in QlikView

Data Reduction & Circular Reference

Fri, 18 Nov 2011 14:02:01 GMT

Hi there,

I wonder anyone can help me. I am trying to data reduction on multiple dimensions and the dimensions are linked to a fact table. If I construct the Section Access as follows,

ACCESS, NTNAME, COSTFILTER, CATFILTER

ADMIN, ERIC.LAM, PET MANAGEMENT, DIRECT

COSTFILTER and CATFILTER are dimension fields linked to Cost Centre and Category dimension tables. At the same time, the dimension tables are linked to the same Spend fact table.

From what I can see, the data reduction/section access relationship creates cricular reference among Section Access, Category, Cost Centre and Spend tables. When I reload the script, there is no warning at all. Does QlikView resolve the circular reference? If not, is that mean it is not possible to have multiple data reduction in my case?

Many thanks in advance,

Eric.

Data Reduction & Circular Reference

ToniKautto — Fri, 18 Nov 2011 14:05:39 GMT

The reduction reduces the content in the tables, so it shoudl not change your data model in general. If you get a circular reference it sounds more like you have added the section access table as a regular table and not as a section access table. Please make sure that you have added the Section Access table definiton and the section application definition.

Data Reduction & Circular Reference

Fri, 18 Nov 2011 14:34:38 GMT

Thanks Toni. I misunderstand section access table is to link to the real data tables. Yes, I copy section access table to normal table to see they have the right relationships. The reason is to debug my section access/data reduction issue, I thought is due to the circular reference.

My problem is the data reduction is not working as I expected. I don't know what I have done wrong.

ACCESS, NTNAME, FILTER, COSTFILTER, CATFILTER

ADMIN, ROSSLYN\ERIC.LAM, COST_CENTRE¬PET MANAGEMENT, *, *

ADMIN, ROSSLYN\ERIC.LAM, L1-CATEGORY¬DIRECT, *, *

ADMIN, ROSSLYN\STEVE.HAYWARD, *, PET MANAGEMENT, INDIRECT

When I login as ROSSLYN\ERIC.LAM (confirm by OSUSER()), the data reduction is on PET MANAGEMENT, INDIRECT which is the data reduction on ROSSLYN\STEVE.HAYWARD not me.

I wonder anyone can help.