topic Instruction on Section access in QlikView

Instruction on Section access

Wed, 18 Apr 2012 19:31:30 GMT

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

Instruction on Section access

Jason_Michaelides — Wed, 18 Apr 2012 20:01:36 GMT

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

Instruction on Section access

Wed, 18 Apr 2012 20:34:37 GMT

Sure I did.

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

Instruction on Section access

Jason_Michaelides — Wed, 18 Apr 2012 22:57:40 GMT

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);

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...

Instruction on Section access

Thu, 19 Apr 2012 13:57:27 GMT

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

Instruction on Section access

Jason_Michaelides — Thu, 19 Apr 2012 14:12:28 GMT

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

Re: Instruction on Section access

Thu, 19 Apr 2012 14:30:59 GMT

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

Re: Instruction on Section access

Jason_Michaelides — Thu, 19 Apr 2012 19:05:28 GMT

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

Re: Instruction on Section access

Thu, 19 Apr 2012 19:36:57 GMT

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,