Section access

[Krish2459_58]

Hi,

We need to implement section acces on the dashboard where we have two business units in the data like below.

The users are able to see only the relavant business data based on their login ID's. 

Business Unit	Product ID	Sales $
BCC	PRD 1	1000
BCC	PRD 2	1001
BCC	PRD 3	1002
BCC	PRD 4	1003
BCC	PRD Invst 1	1004
BCC Invst	PRD Invst 2	1005
BCC Invst	PRD Invst 3	1006
BCC Invst	PRD Invst 4	1007
BCC Invst	PRD Invst 5	1008
BCC Invst	PRD Invst 6	1009

[Muthukumar_77 · Accepted solution]

Try this,

Table1:

Load [Business Unit],

[Product ID],

    [Sales $],

    Upper([Business Unit]) as SA_KEY

Inline [

Business Unit,Product ID,Sales $

BCC PRD,1,1000

BCC PRD,2,1001

BCC PRD,3,1002

BCC PRD,4,1003

BCC PRD,Invst 1,1004

BCC Invst,PRD Invst 2,1005

BCC Invst,PRD Invst 3,1006

BCC Invst,PRD Invst 4,1007

BCC Invst,PRD Invst 5,1008

BCC Invst,PRD Invst 6,1009

];

Section_Access:

Load * INLINE [

ACCESS,USERID,SA_KEY               

USER,AD_DOMAIN\ADMIN,*

USER,AD_DOMAIN\A,BCC PRD

USER,AD_DOMAIN\B,BCC INVST

];

Concatenate(Section_Access)

Load Distinct 'USER' as ACCESS,

'AD_DOMAIN\DUMMY' as USERID,

    SA_KEY

Resident Table1;

Section Access;

SA:

Load ACCESS,

USERID,

    SA_KEY

Resident Section_Access;

Section Application;

[p_verkooijen · Accepted solution]

Don't forget the SA_SCHEDULER https://community.qlik.com/t5/Official-Support-Articles/Internal-sa-scheduler-mandatory-to-reload-ap...

Section Access;
LOAD * INLINE [
ACCESS, USERID, SA_KEY
ADMIN, INTERNAL\SA_SCHEDULER,*
USER,AD_DOMAIN\ADMIN,*
USER,AD_DOMAIN\A,BCC PRD
USER,AD_DOMAIN\B,BCC INVST
];