topic Re: Issue with reduction in section access in QlikView

Issue with reduction in section access

Wed, 14 Aug 2013 06:25:13 GMT

binary load blah blah blah;

section access;

LOAD

* INLINE [

    ACCESS, NTNAME, "Sale Year"
    ADMIN, domain1\user1, 2008
    USER, domain1\user2, 2009
    USER, domain2\user1, 2010
    USER, domain2\user2,
];

Section Application;
LOAD * INLINE [
"Sale Year"
2009
2010
2011
2012
2013
];

I want to reduced based on a Sale Year which is the column in the data model. This doesn't work at all... Either from the desktop or from the access point. Can you kindly help? domain2\user2 should have access to all years, but the other users need to be set up as seen here.

Re: Issue with reduction in section access

tresB — Wed, 14 Aug 2013 06:34:32 GMT

all the year values have to be there in the section access. try like this:

Section Access;

LOAD

* INLINE [

    ACCESS, NTNAME, "Sale Year"
    ADMIN, domain1\user1, 2008
    USER, domain1\user2, 2009
    USER, domain2\user1, 2010
    USER, domain2\user2, 2008

USER, domain2\user2, 2009

USER, domain2\user2, 2010

USER, domain2\user2, 2011

USER, domain2\user2, 2012

USER, domain2\user2, 2013

];

Section Application;
LOAD * INLINE [
"Sale Year"
2009
2010
2011
2012
2013
];

Re: Issue with reduction in section access

Wed, 14 Aug 2013 06:35:37 GMT

Hi,

Make sure, the field "Sales Year" is exists in your data model ( which is in your binary load). Also, Put the check mark for the option Document Properties -> Opening -> "Initial Data Reduciton Based on Section Access".

Re: Issue with reduction in section access

Wed, 14 Aug 2013 06:36:32 GMT

Yes, it exists and i have done the set up in the Opening tab as well. Still no luck.

Re: Issue with reduction in section access

Wed, 14 Aug 2013 06:41:55 GMT

Hi,

I have a small doubt from your Section Access: How come user1 have both ADMIN and USER as ACCESS types?

Ok, when you have logged in to your application by USER1 then how the applicaiton can treat you, whether you are ADMIN or USER?

Re: Issue with reduction in section access

tresB — Wed, 14 Aug 2013 06:44:23 GMT

we are missing one basic:

Everything under section access has to be in CAPITAL letters.

Re: Issue with reduction in section access

Wed, 14 Aug 2013 06:45:58 GMT

actually it is a typo, different users in different domains. apologies.

Re: Issue with reduction in section access

Wed, 14 Aug 2013 06:46:26 GMT

why? my osuser() returns domain name in caps and user name in lowercase.

Re: Issue with reduction in section access

Wed, 14 Aug 2013 06:50:14 GMT

Hi,

Is it possible to attach your application?

Re: Issue with reduction in section access

tresB — Wed, 14 Aug 2013 06:53:40 GMT

Though, this does not apply to INLINE data, but if you are loading via an external data source, must be loaded in upper case.

Re: Issue with reduction in section access

Wed, 14 Aug 2013 06:56:54 GMT

actually the data is just the year, which is a numeral.

Re: Issue with reduction in section access

tresB — Wed, 14 Aug 2013 06:59:50 GMT

I was talking about section access data.

Re: Issue with reduction in section access

Wed, 14 Aug 2013 07:21:37 GMT

hmm. does anyone have an existing working example?

Re: Issue with reduction in section access

Wed, 14 Aug 2013 07:30:48 GMT

Hi,

Re: Issue with reduction in section access

Wed, 14 Aug 2013 07:37:27 GMT

thanks Venu. It works fine, but how about NTNAME. I am using a NTNAME and it still doesn't work. Because I cannot afford to take username as the input.