Section Access reduction with Binary Load

[#1]

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,

     XX

    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

[Siva_Sankar]

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

[#3]

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

[tresesco · Accepted solution]

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

[#5]

sorry what is the user id password?

[tresesco]

credentials.(userid/pass)

admin - A, admin

user - U, user

[#7]

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.

[tresesco]

please share your sample app.

[#9]

@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

[tresesco]

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?