topic Re: Section Access reduction with Binary Load in QlikView

Section Access reduction with Binary Load

Fri, 30 Aug 2013 03:58:08 GMT

Hi, My situation is like this. I have a data extract document that runs on the client site and gets ftped into our local server which is binary loaded into the application qvw. Now i want to implement the Section Access Reduction in this application document. The original qvw doesn't have any section access.

BINARY a.qvw; //Loads the customer data extracted on their server.

SECTION ACCESS;

Directory;

LOAD ACCESS,

NTNAME,

FROM

Security\ControlSheet-POS.xlsx

(ooxml, embedded labels, table is Sheet1);

load * inline

[

XX, Domain

Domain1, Domain1

Domain2, Domain2

Domain3, Domain3

];

Now the excel file is something like this.

ACCESS	NTNAME	XX
ADMIN	User1	Domain1

With this data, I login as User1 and expect to see only the data for Domain1, but I get to see all the data. Whatever I have done is not working. Domain is a column name in the original data model in a.qvw file.

Please help.

Thanks,

Ram

Re: Section Access reduction with Binary Load

Siva_Sankar — Fri, 30 Aug 2013 04:18:37 GMT

http://community.qlik.com/message/334736#334736

Re: Section Access reduction with Binary Load

Fri, 30 Aug 2013 04:33:30 GMT

sorry, this hasn't helped. Mine is not a case of SA in 2 documents at all.

Re: Re: Section Access reduction with Binary Load

tresB — Fri, 30 Aug 2013 05:16:51 GMT

PFA.

It should normally work if all the basics (1. Initial data Reduction Based on Section Access - is checked 2. All values under section access are being taken in capital when INLINE load) are set properly.

credentials.

admin - A, admin

user - U, user

Re: Section Access reduction with Binary Load

Fri, 30 Aug 2013 05:24:47 GMT

sorry what is the user id password?

Re: Re: Section Access reduction with Binary Load

tresB — Fri, 30 Aug 2013 05:30:20 GMT

credentials.(userid/pass)

admin - A, admin

user - U, user

Re: Section Access reduction with Binary Load

Fri, 30 Aug 2013 06:50:06 GMT

Your example seems to be correct. When I try to follow that, my document gets locked. It says failed to open document. It looks like it isn't working for me.

Re: Section Access reduction with Binary Load

tresB — Fri, 30 Aug 2013 06:56:10 GMT

please share your sample app.

Re: Section Access reduction with Binary Load

Fri, 30 Aug 2013 07:23:12 GMT

@TRESESCO

This is the code.

BINARY InsightData.qvw; //Loads the customer data extracted on their server.

SECTION ACCESS;

Directory;

LOAD ACCESS,

NTNAME,

[Store Name] as STORE_NAME

FROM

Security\ControlSheet-POS.xlsx

(ooxml, embedded labels, table is Sheet1);

Section Application;

Directory;

LOAD [Store Name] as STORE_NAME

resident STORE;

Contents of the excel File:

ACCESS	NTNAME	Store Name
ADMIN	DOMAIN1\USER1	STORE1
ADMIN	DOMAIN1\USER2	STORE2
ADMIN	DOMAIN1\USER3	STORE3
ADMIN	DOMAIN1\USER4	STORE4

Thought it would be a simple implementation but has taken my whole day without any success. Please help.

Thanks,

Ram

Re: Section Access reduction with Binary Load

tresB — Fri, 30 Aug 2013 07:43:49 GMT

For NTNAME, you have to give the original information in the excel file. It actually takes the windows user and domain name while trying to open the document. For example, if your windows ID is Ram and your domain (Windows) is Organisation1, you have to put the values in the excel like :

ACCESS	NTNAME	Store Name
ADMIN	ORGANIZATION1\RAM	STORE1
ADMIN	ORGANIZATION1\PITTER	STORE2
ADMIN	ORGANIZATION1\USER3	STORE3
ADMIN	ORGANIZATION1\USER4	STORE4

Is that being done correctly?

Re: Re: Section Access reduction with Binary Load

Sun, 01 Sep 2013 23:29:15 GMT

Hi treseco, Thanks for all your help. I have modified according to what you said. But it doesn't seem to work at all. Once I set this up with Strict exclusion, I get an access denied. I have attached the files without a Strict exclusion here. Please see what I do wrong.

Thanks,

Ram

Re: Section Access reduction with Binary Load

Mon, 02 Sep 2013 01:52:38 GMT

Also can you please check your sample document that dealt with region using NTNAME rather than User/Password and see if that works?

Re: Section Access reduction with Binary Load

tresB — Mon, 02 Sep 2013 05:08:01 GMT

Hi Ram,

Sorry, i could not check your file for obvious reason, NTNAME checks the windows id for authentication and there i fail to open your file. And yes, i checked with my domain/id information in the sample file and it worked fine to filter region. i would suggest you to try various options like, load the section access data INLINE(use all data in capitals) and test if it is working. Narrow down the issue area and finally you would be able to get it done.

Re: Section Access reduction with Binary Load

Tue, 03 Sep 2013 06:57:12 GMT

I have managed to get it work now. Thanks for your help. I had done some silly mistake in the Section Application mapping.