Section access - choose data and values

[#1]

I have some few questions:

Lets assume i have two tabs:

Tab 1: Includes my  hidden script

Tab 2: Includes all my dimensions and facts

Now i want to create section access based on some values from a dimension. Here i got some problems understanding how it relates to my dimension.

Lets take my hiddenscript tab:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, OptionText

    admin, admin, admin, *

    user, hans, 1234, Open

    user, gert, 1234, Closed

]; 

Section Application;

It looks like this:

I want hans to see Open and gert to see only Closed.

Optiontext is from my Dimension: DimSalesStatus

which looks like this:

QUALIFY*;

UNQUALIFY SalesStatusKey;

DimSalesStatus:

LOAD SalesStatusKey,

    OptionID,

    OptionText;

SQL SELECT *

FROM DW.dbo.DimSalesStatus;

UNQUALIFY*;

My questions is then - How should my section access script really look like to filter on open and closed for gert and hans?

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, OptionText

    admin, admin, admin, *

    user, hans, 1234, Open

    user, gert, 1234, Closed

]; 

Section Application;

and then what?

Cheers

Thomas

[#2 · Accepted solution]

Hi,

to implement section access we need to have common dimension in both section access and section application.

and both field names and values should be in capital letters.

and you need to enable intial data reduction based on section access option in  document properties on opening tab.

see the attached file