Access on Region

[#1]

Hi all,

I'm stuck on giving specific people access to certain regions in the dashboard.

Section Application;

LOAD REGION,

     Fee

FROM

[Advanced User Access Testing.xlsx]

(ooxml, embedded labels, table is Sheet1);

SECTION    Access;

LOAD ACCESS,

     USERID,

     PASSWORD,

     REGION

FROM

[Advanced User Access Testing.xlsx]

(ooxml, embedded labels, table is Sheet2);

my Regions are: NA, EMEA, LATAM, ASIA and the fees are just a made up # for now.

My access are:

ACCESS	USERID	PASSWORD	REGION
ADMIN	ADMIN	ADMIN
USER	USER	USER
USER	A	A	NA
USER	B	B	EMEA
USER	C	C	*

But when I log in as user B i can see everything still

[Gysbert_Wassenaar]

Did you enable the options Initial Data Reduction Based on Section Access and Strict Exclusion on the Opening tab of the Document Properties window?

[Anonymous]

Hi,

Try below mentioned script.

PFA attached qvw for the same.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, REGION

    ADMIN, ADMIN, ADMIN, *

    USER, A, A, EMEA

    USER, C, C, LATAM

    USER, E, E, NA

    USER, DUMMY1, DUMMY1, ASIA

];

Section Application;

Table:

LOAD * INLINE [

    REGION, NAME

    EMEA, A

    EMEA, B

    LATAM, C

    LATAM, D

    NA, E

    NA, F

    ASIA, G

    ASIA, H

    EMEA, I

];

Note: Enable property in settings (Settings-> Document Properties -> Opening -> "Initial Data Reduction Based on Section Access")

[Anonymous]

Hi,

You can refer to Section Access for more information.