Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.