Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

Section Access

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.

1 Solution

Accepted Solutions
MK9885
Master II
Master II

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.

View solution in original post

4 Replies
MK9885
Master II
Master II

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

rittermd
Master
Master
Author

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.

MK9885
Master II
Master II

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.

rittermd
Master
Master
Author

Using Upper instead of Text on the field in the table worked.  Thanks