Limit the access based on selection criteria

[danialier]

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

[ecolomer]

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

[#3]

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

[djsampat]

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