data reduction based on session access

[#1]

Hi all,

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

Thanks a lot!

Roberta

[stephencredmond]

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

[#3]

Thanks Stephen

[#4]

I'm obviously referring to section access 🙂

[hugo_andrade]

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?

[Anonymous]

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]

It worked perfectly. Thanks

[#8]

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.

[Marcio_Campestrini]

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