Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to apply section access to two fields (combined as Composite key) but getting error and data loads takes time in hours.
Any pointers how to achieve it ?
Two fields on which section access to be applied - Products and Categories
I want section access to work in way that when i select Product only listed categories in section access should display for particular user
It is not quite clear. Can share your code?
I am trying to code something like this:
Section Access;
Load * inline
[
ACCESS ,USERID ,PRODUCTID,CATEGORIES, OMIT
];
I have to limit Categories as per following:
User a can see only PRODUCT A and only one of the category below
User b can see all categories under product a
You need to explicitly populate all combinations of reduction field values that you want each end-user to see. Let say you have 3 Categories A1,A2,A3 under PRODUCT A. Your Section Access table (for Qlik Sense) should be:
Section Access;
Load * inline
[
ACCESS ,USERID ,PRODUCTID,CATEGORIES, OMIT
ADMIN, INTERNAL\SA_SCHEDULER,,,
USER, UserA, PRODUCT A, A1,
USER, UserB, PRODUCT A, A1,
USER, UserB, PRODUCT A, A2,
USER, UserB, PRODUCT A, A3,
];
Section Access table is no special than other tables in your data model except for the fact that it is hidden from users. If your reload takes long time, Section Access isn't likely to be the cause.
If you still get error, some screencaps of the error messages should be helpful.
What error?
What does the detail for your section access records look like?
How much data?
What's the load time without Section Access?