Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have narrowed my problem down to this. I think I have a mismatch in the value in my section access table and the value in the reduction field.
Here is my inline table:
Section Access;
LOAD * INLINE [
ACCESS, USERID ,SALESMANID
USER,DOMAIN\MRITTER,'2310'
];
The reduction field (SALESMANID) is a text field and contains values like 209, 0209, n209.
If I put a value in my inline that contains a character like n209, then my section access works. But if I put in a numeric value like 0209 then I get access denied. I have verified that this value exists in the table.
What do I need to do to make sure that the value in my section access is identical to the value in the table? I tried using text() but that didn't change anything.
Section access;
Star is *;
LOAD * INLINE [
ACCESS, USERID ,SALESMANID
USER,INTERNAL\sa_scheduler,*
USER,DOMAIN\MRITTER,2310
];
Section Application;
Try this?
The above script works for me in SA app if not check your USERID in text box by osuser() ?
And you should have your SALESMANID in Upper Case in your Fact or Dimension table, wherever that dimension is...
Ex: if SALESMANID is coming from Fact Table...
write
Upper (SalesManID) as SALESMANID and use SALESMANID in SA Inline code.
Section Access;
LOAD * INLINE [
ACCESS, USERID ,SALESMANID
ADMIN,INTERNAL\sa_scheduler,*
USER,DOMAIN\MRITTER,2310
];
Remove ' ' from the numeric value?
and maybe add Qlik Scheduler ID as Admin
I have tried no quotes, single quotes, and double quotes and none of them work.
I added SA_Scheduler and that didn't work either.
Section access;
Star is *;
LOAD * INLINE [
ACCESS, USERID ,SALESMANID
USER,INTERNAL\sa_scheduler,*
USER,DOMAIN\MRITTER,2310
];
Section Application;
Try this?
The above script works for me in SA app if not check your USERID in text box by osuser() ?
And you should have your SALESMANID in Upper Case in your Fact or Dimension table, wherever that dimension is...
Ex: if SALESMANID is coming from Fact Table...
write
Upper (SalesManID) as SALESMANID and use SALESMANID in SA Inline code.
Using Upper instead of Text on the field in the table worked. Thanks