Section Access in Qliksense

[krishna20]

Hi Folks,

Could anyone help me on implementation of section access in Qliksense. I have tried in many ways but somewhere the logic is not working properly.

My script is here

SECTION Access;
STAR is *;
SA:
LOAD
UPPER(USERID) AS USERID,
upper(ACCESS) AS ACCESS,
upper(subfield(MARKET,';')) AS MARKET,
upper(subfield(BG,';')) AS BG,
upper(subfield(BU,';')) AS BU,
REDUCTION AS REDUCTION


FROM
[lib://----/SectionAccessxlsx]
(ooxml, embedded labels, table is Sheet4)
WHERE NOT IsNull(USERID) and Active='Y';

Concatenate

load Distinct 'ADMIN' AS ACCESS,
'ID\DUMMY' AS USERID,
'NUM' as REDUCTION,
Upper(Market) as MARKET,
Upper(BG) as BG,
Upper(BU) as BU

Resident Fact;

SECTION Application;

@hic ,Sunny_talwar,Kaushiknsolanki,Mayilvahanan

[krishna20]

Any inputs folks??

[hic · Accepted solution]

You need to describe the symptoms of the problem: What is it that doesn't work?

However, I can right away see that you use multiple reducing fields, and that often causes problem. See more on https://community.qlik.com/t5/Qlik-Design-Blog/Basics-for-complex-authorization/ba-p/1465872

HIC

[krishna20]

Hi Henric_Cronström,

Thanks for suggesting and I followed the same which you have mentioned in article.But not working as expected, getting access denied error. Am i missing anything in implementing the logic?

Is any settings needs to be changed in Qliksense QMC? Please advise.

Active	ACCESS	USERID	MARKET	BG	BU
Y	USER	xxx\1234567	*	*	HEALTH
Y	USER	xxx\1234567	*	*	PERSONAL
Y	ADMIN	xxx\2567856	*	*	*

SECTION Access;
STAR is *;
SA:
LOAD [MARKET] &'|'& [BG] &'|'& [BU] as %AuthID ,
UPPER(USERID) AS USERID,
upper(ACCESS) AS ACCESS

FROM
[lib://SA/Test/Datamodel/SectionAccess.xlsx]
(ooxml, embedded labels, table is Sheet4)
WHERE NOT IsNull(USERID) and Active='Y';

Load [Market] &'|'& [BU] &'|'& [BU] as AuthID ,
[Market] &'|'& [BG ] &'|'& [BU] as %AuthID
Resident Fact ;

Load [Market] &'|'& [BG] &'|'& [BU] as AuthID ,
[Market] &'|'& [BG] &'|'& '<ANY>' as %AuthID
Resident Fact ;

Load [Market] &'|'& [BG] &'|'& [BU] as AuthID ,
[Market] &'|'& '<ANY>' &'|'& [BU] as %AuthID
Resident Fact ;

Load [Market] &'|'& [BG] &'|'& [BU] as AuthID ,
'<ANY>' &'|'& [BG] &'|'& [BU] as %AuthID
Resident Fact ;

Regards

Krishna

[jp_golay]

You can now test our new Product SAM that will fully automate Section Access Generation product.

It is no longer necessary to maintain a section access list in Excel or in your database, SAM offers you a complete web application that will secure all your data accesses.

A user can request access to an application with a simple form. Then administrators get notified and can assign the RESTRICTIONS and OMITS from the proposed fields values. User access are generated from on a single line per user, no need to generate tedious cartesian products and include all values to get a "*" value working correctly .

Moreover SAM is able to generate an automatic access section from the authorizations of the QMC, and Reverse Engineer existing section Access a time saving for simple cases.

More details on our website or contact me at jp.golay@ebiexperts.com