Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have developed one dashboard with Section access. Am able to access the application with my id in server, once published the same app I am getting don't have permission error.
I have an license and configured my id in the section script also.
Kindly help on this issue.
thanks in Advance,
Regards,
sudhakar
Also, the 'ALL' value in your three section access fields doesn't link to anything because it is a distinct but meaningless value to QlikView. Replace it with a *, and put the following statement before your section access LOAD statement:
STAR IS *;
Keep in mind also that if you are defined as ADMIN in section access, you will always be able to open a QVW document in desktop because the data reduction rules are partially switched off. In the AccessPoint however, this nice trick won't work and you will be treated as any other USER.
Best,
Peter
HI Sudhakar,
Replace All with * and use STAR IS *;
As per my knowledge even * includes only values in Section access code and there are no values other then * in access section.
For Ex:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REGION
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, AFRICA
USER, USER2, U2, AMERICA
USER, USER3, U3, ASIA
USER, USER4, U4, EUROPE
USER, USER5, U4, AMERICA
USER, USER5, U5, *
];
Section Application;
SALES:
LOAD * INLINE [
REGION, PROFIT
AFRICA, 1000
AMERICA, 2000
ASIA, 3000
EUROPE, 4000
OCEANIA, 5000
];
USER5 will be able to see all regions listed in the reduction field REGION except for
Even if USER5 has “*“ for the REGION reduction field, star means “all listed values”
not all values for the field. Since no USER has OCEANIA listed for the REGION field,
USER5 will not have access to the values for OCEANIA.
If we want USER5 to see OCEANIA as well, we need to add an extra line in our section
access solution
USER, USER5, U5, OCEANIA
Hope this helps.
I have removed the %columns from Section Access and replaced the All with *.
now its working fine.
thank you
I have removed the %columns from Section Access and replaced the All with *.
now its working fine.
thank you