topic Re: Row level Section access- based on dashboard user name in Reporting Service & Alerting

Row level Section access- based on dashboard user name

Noob3 — Tue, 13 Aug 2024 09:18:26 GMT

Hi All,

Need Help.

I want to apply row-level access based on the user who is accessing the dashboard.

The user should see and search only the rows where the username (who is accessing the dashboard) matches the value in the column "assigneduser".

All users are in Active directory.

i applied the section access as below , but it's not working.

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REDUCTIONFIELD
ADMIN, dir\<MySelf>, *
ADMIN,dir\Analytics.Engineering, *
ADMIN, dir\Analytics.Prod.Support, *

ADMIN, INTERNAL\SA_SCHEDULER, *
USER, dir\rahul.t, rahul.t
USER, dir\rohit.k, rohit.k
USER, dir\chetan.d, chetan.d
USER, dir\sai.p, sai.p
];

Section Application;

Adminasset:
LOAD
AutoNumber(assetid) as AssetID,
assetid as AdminassetId,
computername,
assigneduser AS REDUCTIONFIELD,
assettype & '-' & pcmodel & '-' & serialnumber as Asset,
assettag

FROM $(vQVDPath)\assetinfo.qvd(qvd)

Re: Row level Section access- based on dashboard user name

MatheusC — Tue, 13 Aug 2024 13:37:30 GMT

@Noob3

Function Upper()

Note: When adding a question, please look for the appropriate forum for your query. This will make it easier and faster to find your solution.

https://community.qlik.com/t5/Official-Support-Articles/How-To-Validate-And-Troubleshoot-Section-Access-Reduction/ta-p/1713023

- Matheus

Re: Row level Section access- based on dashboard user name

Noob3 — Wed, 14 Aug 2024 09:12:27 GMT

Hi MatheusC,

Thank you for your response.

I tried the uppercase function, and the script runs fine without any errors.
but it seems all users are still able to see all rows,

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REDUCTIONFIELD
ADMIN, DIR\<MySelf>, *
ADMIN, DIR\2758_Qlik_STG, *

ADMIN, INTERNAL\SA_SCHEDULER, *
USER, DIR\RAHUL.T, RAHUL.T
USER, DIR\ROHIT.K, ROHIT.K
USER, DIR\CHETAN.D, CHETAN.D
USER, DIR\SAI.P, SAI.P
];

Section Application;

Adminasset:
LOAD
AutoNumber(assetid) as AssetID,
assetid as AdminassetId,
computername,
upper(assigneduser) AS REDUCTIONFIELD,
assettype & '-' & pcmodel & '-' & serialnumber as Asset,
assettag

FROM $(vQVDPath)\assetinfo.qvd(qvd)

Re: Row level Section access- based on dashboard user name

MatheusC — Wed, 14 Aug 2024 12:25:21 GMT

@Noob3

Try putting user restrictions first and then those with asterisks *

- Matheus

Re: Row level Section access- based on dashboard user name

Noob3 — Wed, 14 Aug 2024 13:13:07 GMT

Tried, but no change.

Also, i just realized that it's not even showing list of users in the column NTNAME.

Re: Row level Section access- based on dashboard user name

MatheusC — Wed, 14 Aug 2024 14:20:08 GMT

For testing I would also advise using an inline table and see the result.

Adminasset:
Load * Inline [

REDUCTIONFIELD
SAI.P
CHETAN.D

];

Then if you haven't visited it yet, check the post above, or review the steps highlighted in the post, to validate the information in your table with the Section Access reduction, so you can apply the restriction.

https://community.qlik.com/t5/Official-Support-Articles/How-To-Validate-And-Troubleshoot-Section-Access-Reduction/ta-p/1713023

Regards!