Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I am trying to implement section access on 2 fields. Following is the structure of my section access file.
ACCESS | E-MAIL ADDRESS | REGION | BUSINESS |
ADMIN | USER1@COMPANYNAME.COM | * | * |
ADMIN | USER2@COMPANYNAME.COM | MAH | B1 |
ADMIN | USER3@COMPANYNAME.COM | IND | B2 |
ADMIN | USER4@COMPANYNAME.COM | * | B1 |
I have created Key using Region and Business in both data model table and section access table as well.
All values and field names are in upper case. I have checked initial data reduction and strict exclusion checkbox as well.
For the above table, first 3 rows cases are working on the Qlikview desktop. case 4 is not working.
Same file I deployed on UAT and allocate CAL. Still on access point I am getting error as failed to open document. user do not have access.
Please help me with this asap.
PFB Section Access script:
STAR is *;
SECTION Access;
LOAD ACCESS,
'COMPANYNAME\'&upper(subfield(trim([E-MAIL ADDRESS]),'@',1)) as NTNAME,
REGION&'|'&BUSINESS as SECTIONACCESSKEY
FROM
[Sectionaccess.xlsx]
(ooxml, embedded labels, table is [Section Access]);
SECTION Application;
For debugging this sort of thing, I would suggest removing the Section Access; part of the code, then looking at the relationships generated for the user that isn't working (since the access aspect will be loaded as a regular table instead of an access table). Usually that helps point you in the right direction for what the problem is.