Discussion Board for collaboration on QlikView Publisher.
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,
Go to Solution.
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.
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, *
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
USER, USER5, U5, OCEANIA
Hope this helps.
Are you able to access the same application from access point if you remove section access code ?
You must be using the NTNAME field in your section access table. Did you enter your credentials as domainname\username ?
yes..am able to access the same application with out section access..
i have used the NTNAme filed in my script. i have given access to particular users based on their Ad Id's
like Domain name\ADID.... but i didn't given the password's.
I guess paswword is not required if we use windows authentication.
Some thing must be wrong with your code or QEMC settings.(Ex: All authenticated etc)
Some times order of the tab (with script code ) also create problems.I had this issue.
Can you post your sample code here ?
Give admin rights to the service account (Qlikview service account) in your section access table. Run the task and see if your access is permitted.
Can you post sample script.
Please find the below sample script. which I have implemented
Section Access;LOAD * INLINE [ ACCESS, NTNAME, %SBU, %LOB, %REGION ADMIN, Domain\zzzz,ALL,ALL,ALL ADMIN, Domain\yyyy,ALL,ALL,ALL ADMIN,Domain\XXXX,ALL,ALL,ALL];Section Application;LOAD * INLINE [ SBU, %SBU AA, ALL_AA Others, ALL_OTHERS GM, ALL_GM Go., ALL_GO HL, ALL_HL EN, ALL_EN];LOAD * INLINE [
LOB, %LOB A, ALL_A B, ALL_B C, ALL_C D, ALL_D E, ALL_E F, ALL_F];LOAD * INLINE [ Region, %REGION West, ALL_WEST South1, ALL_SOUTH1 Gulf, ALL_GULF];
remove % from section access columns.it did not work for me in our application