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
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.
Hi,
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 ?
Peter
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 ?
Sudhakar,
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.
Regards,
Karthi
Hi Sudhakar,
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