Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

data reduction based on session access

Hi all,

can anyone explain me how this is possible, also posting an example?

Thanks a lot!

Roberta

8 Replies
stephen-a_redmo
Valued Contributor II

data reduction based on session access

Hi Roberta,

Here is a very simple example:


Section Access;
LOAD * INLINE [
ACCESS, USERID, LINKFIELD
ADMIN, ADMIN, *
USER, England, E
USER, Ireland, I
USER, Scotland, S
USER, Wales, W
];
Section Application;
SecurityLink:
Load * Inline [
LINKFIELD, Country
E,England
I,Ireland
S,Scotland
W,Wales
];

Load * Inline [
Country,Sales
England,100
Ireland,99
Scotland,98
Wales,97
];


In Document Properties, on the Opening Tab, set "Initial Data Reduction Based On Section Access" to checked.

Useful for testing, in User Preferences, on the General tab, to turn off "Remember Login Credentials until QlikView Exits". This means that you don't have to keep shutting down and restarting QlikView to change user, just close and re-open the QVW.

Note that I have a LINKFIELD field in the section access - all the section access fields are capitalized names. So I can't use "Country" directly here. This is why I have a Link table.

Have fun.

Stephen

Not applicable

data reduction based on session access

Thanks Stephen

Not applicable

data reduction based on session access

I'm obviously referring to section access Smiley Happy

hugo_andrade
Contributor II

Re: data reduction based on session access

What's the behavior expected?

Because I was expecting to use the same QVW for multiple users but each one will only see their data. And the ADMIN user would be able to see all the data. But the wildcard isn't working on QV 11. Suggestions to make it work?

mov
Esteemed Contributor III

Re: data reduction based on session access

Hugo,

It is unlikely that your problem has anything to do with QV11.  Try to remove *, so in the example above it will be:

Section Access;

LOAD * INLINE [

ACCESS, USERID, LINKFIELD

ADMIN, ADMIN,

USER, England, E

USER, Ireland, I

USER, Scotland, S

USER, Wales, W

];

Regards,

Michael

hugo_andrade
Contributor II

Re: data reduction based on session access

It worked perfectly. Thanks

Not applicable

Re: data reduction based on session access

Hi,

Did anyone use publisher to reload and distribute?

I built something similar, and when i reload and distribute by publisher, the access works, i have the correct reduction, but the NTNAME appear to be the service account name which is used by the distribution service.

Is this a bug or section access doc should not use publisher to do reload and distribution?

Thanks.

MCampestrini
Valued Contributor

Re: data reduction based on session access

Stephen, thanks the post. It made clear to me.

Márcio Rodrigo Campestrini
Community Browser