Section access - choose data and values

Fri, 05 Jul 2013 11:18:43 GMT

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

Re: Section access - choose data and values

Fri, 05 Jul 2013 11:40:35 GMT

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

topic Section access - choose data and values in QlikView

Section access - choose data and values

Re: Section access - choose data and values