Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thanks all for your answers. Unfortunately I still did not succeed on that...
I'm attaching the QV file.
Could someone work on that QV file and make the necessary updates so the section access works ?
Thanks,
Dani
Hello,
I have a QV doc showing revenues per region (AMS / EMEA / APJ). This is a really simple QV with one bar chart showing revenues and one list Box where you can select the region (for which you want to see the revenue).
I'm planning to grant access to lot of people. However I want the folks from AMS to only be able to see AMS revenues, same with EMEA folks with EMEA revenues and same with APJ folks with APJ revenue.
How I can ensure this "privacy" based on user profile ?
thks,dani
For this one solution is use SECTION ACCESS and assign for each user o group their region and when you open the document select only the data selected by region
Hola! Dani.
Puedes utilizar el Section Access y este lo puedes hacer en base al campo que desees.
Ejemplo:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REDUCTION
Hi Dani,
Use Section Access like below:-
Section Access;
star is *;
LOAD ACCESS,
NTNAME,
USERID,
PASSWORD,
If(REGION='',null(),REGION) as REGION;
LOAD * inline [
ACCESS,NTNAME,USERID,PASSWORD,REGION
ADMIN, *, ADMIN, ADMIN,
USER, *, U1, U1,
USER, *, U2, U2, ALL, ALL, ALL
USER, <DOMAIN/USERNAME>, *, *, *
USER, AMS\DANI, *, *, AMS
USER, APJ\DANI, *, *, APJ
];
star is;
Section Application;
Security:
LOAD DISTINCT REGION,
REGION
RESIDENT ALLREGIONSLIST;
LOAD DISTINCT REGION,
'ALL' as REGION
RESIDENT ALLREGIONSLIST;
If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer
Regards
Dhruv