Instruction on Section access

[#1]

Hi,

Can anybody provide me with instruction on using section access to reduce data per user.

I have created an excel file with the following fields, and added the query to the script as follow:

Section Access;

LOAD NTNAME,

     NTDOMAINSID,

     [ACCESS],

     MANUFACTLBL

FROM

C:\QlikviewReports\Sourcedocuments\SectionAccess\ByBrandNameManagers.xlsx

(ooxml, embedded labels, table is Sheet1);

Section Application;

My Excel file looks like:

NTNAME	NTDOMAINSID	ACCESS	MANUFACTLBL
Administrator	S-1-5-21-3733409033-2078656443-484652593	ADMIN	*
khowell	S-1-5-21-3733409033-2078656443-484652593	USER	Cisco

The MANUFACTLBL is the field I want to use to reduce data.

I have checked the box for Initial Data Reduction Based On Section Access

I also checked the reduce data box on Security tab.

When I load the docuemnt and open it, it asks me for username and password and I tried to put My QlikView Id(same one I use to open the access point)

but it doesn't work

Anybody can help me please

Thxs,

Badr

[Jason_Michaelides]

Have you checked the "Initial Data Reduction Based on Section Access" checkbox in Document Properties > Opening?

[#3]

Sure I did.

It is asking me for User ID and Password and it doesn't accept mine!

[Jason_Michaelides]

I don't think the field to reduce on should be in the Section Access part of the script.  Try changing your load script to be like this:

Section Access;

LOAD

     NTNAME,

     NTDOMAINSID,

     [ACCESS]

FROM

C:\QlikviewReports\Sourcedocuments\SectionAccess\ByBrandNameManagers.xlsx

(ooxml, embedded labels, table is Sheet1);

Section Application;

Security:

LOAD

     NTDOMAINSID,

     MANUFACTLBL

FROM

C:\QlikviewReports\Sourcedocuments\SectionAccess\ByBrandNameManagers.xlsx

(ooxml, embedded labels, table is Sheet1);

<rest of your script>

If you have the data reduction box checked then this should do it.  Remember you must be in the security spreadsheet as ADMIN or you will not get access!!

Hope this helps,

Jason

NOTE: Ensure you are using NTDOMAINSID and not NTSID.  I always use NTNAME as it's easier to track...

[#5]

Hi,

Do you mean

:

Security:

LOAD

     NTNAME,

     MANUFACTLBL

FROM

C:\QlikviewReports\Sourcedocuments\SectionAccess\ByBrandNameManagers.xlsx

(ooxml, embedded labels, table is Sheet1);

Not sure if this is the right solution, it didn't work for me

Regards

[Jason_Michaelides]

Yep - that's it.  That's how I've used it in the past.  Maybe ensure the NTNAMES are all upper case?

[#7]

Thxs, even this didn't work.

I don't understand what's wrong1

I have added the following to my script:

Section Access;

LOAD NTNAME,

     NTDOMAINSID,

     [ACCESS]

     //MANUFACTLBL

FROM

C:\QlikviewReports\Sourcedocuments\SectionAccess\ByBrandNameManagers.xlsx

(ooxml, embedded labels, table is Sheet1);

Section Application;

Security:

LOAD

     NTDOMAINSID,

     MANUFACTLBL

FROM

C:\QlikviewReports\Sourcedocuments\SectionAccess\ByBrandNameManagers.xlsx

(ooxml, embedded labels, table is Sheet1);

I have checked the box to intial dat reduction on Document prperties/Opening

and I have checked the the box on data reduce on Security tab.

still not working.

Would you mind looking at the attached excel file to see if I have anything wrong there.

My ID is KHOWELL and I am trying to set my self as user so I can test it.

Thxs

[Jason_Michaelides]

OK - sorry I got a bit wrong earlier.  I have been playing with this and seem to have it working.  Try the attached docs - one of the QVW files has the section access script commented out.  If your NTNAME is KHOWELL, it should open fo you and show just the Dell data.

Hope it helps,

Jason

[#9]

Hey Jason,

I have figured out what was wrong..

under MANUFACTURERLBL field in the excel file the data was not Capital.

I have fixed it and everythings seem to work fine.

except that I am getting an additional Value in the document called Other which doesn't show up on the server. but only on the document.

Regards,