Omit function in qlik sense section access

[UserID2626]

hi,

below is an section access script which i used

Section Access:

LOAD * INLINE[

USER,ACCESS,OMIT

ADMIN,INTERNAL\SA_SCHEDULER,

USER,DOMAIN\ADMIN,

USER,DOMAIN\XYZ,SALES_ID

USER,DOMAIN\ABC,SALES_ID

];

Section Application;

Load 

Sales_date,

Sales_ID,

Sales_count

from Sales_table;

Only admin and user XYZ have access to create visuals using sales_table. and ABC can able to see the table in stream once published by admin.

created a straight table(dimension: sales_ID and sales_date, metric-sales_count)

when using OMIT function in section access, whether it will hide the column(SALES_ID) in visual for user XYZ(so that XYZ can see straight table with two columns date and sales_count, but sales_ID is also implemented in that but user XYZ cant able to see in visual created by admin) or it will hide the data  in data manager(so that the user XYZ cant able to use SALES_ID dimension for creating charts)

and also  how OMIT will reflect for the user ABC in stream once the app is published

Thanks...

[dwforest]

Not sure if its a typo but you have sales_ID and Sales_ID... case matters
I'd also use something more different than SALES_ID vs Sales_ID, like SALES_ID_R and SALES_ID_ALL just to make it clearer.
If putting into a table you;'d have to conditionally hide it as well if the user doesn't have access to the field, otherwise the table will error with "Invalid Dimension" as it will literally be removed for those users without access.

[UserID2626 · Accepted solution]

yes, i am getting invalid visualization.

I tried using the method given in below link(point 2)

https://community.qlik.com/t5/New-to-Qlik-Sense/Section-Access-OMIT-causes-Invalid-Visualisation-err...

the OMIT was applied was applied and getting correct result.

[zerwan]

Please, could you provide the script that you wrote?

[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