topic Re: data reduction based on session access in QlikView

data reduction based on session access

Tue, 07 Jul 2009 17:16:49 GMT

Hi all,

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

Thanks a lot!

Roberta

data reduction based on session access

stephencredmond — Tue, 07 Jul 2009 17:34:22 GMT

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

data reduction based on session access

Tue, 07 Jul 2009 17:56:46 GMT

Thanks Stephen

data reduction based on session access

Thu, 09 Jul 2009 21:47:14 GMT

I'm obviously referring to section access 🙂

Re: data reduction based on session access

hugo_andrade — Sat, 30 Jun 2012 18:03:21 GMT

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?

Re: data reduction based on session access

Anonymous — Sat, 30 Jun 2012 23:09:23 GMT

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

Re: data reduction based on session access

hugo_andrade — Tue, 03 Jul 2012 19:11:05 GMT

It worked perfectly. Thanks

Re: data reduction based on session access

Tue, 30 Apr 2013 06:32:50 GMT

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.

Re: data reduction based on session access

Marcio_Campestrini — Mon, 26 May 2014 18:38:29 GMT

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