topic Re: Section Access Help in QlikView

Section Access Help

Thu, 19 Feb 2015 17:32:54 GMT

Hi All,

I have section access implemented in the application for a particular sheet in the application. After reloading the application, correct data is displayed on the dashboard. But when I save and reopen the application again, the data displayed only on that particular tab is halved. Can someone please help me

Re: Section Access Help

Thu, 19 Feb 2015 17:54:16 GMT

Hi,

You will need to give more details around the problem.

Are you using NTNAME or USERID?? Test your section access script using USERID.

Just a guess, if you have used NTNAME in your script and when you repoen your application, entitlement might be applied on your id.

Thanks & Regards

Re: Section Access Help

Thu, 19 Feb 2015 18:16:49 GMT

I tried using USERID in place of NTNAME as well. But still the issue persists.

Re: Section Access Help

Thu, 19 Feb 2015 18:50:31 GMT

Admin rights are not being set properly. Can someone help me with this

Re: Section Access Help

Anonymous — Thu, 19 Feb 2015 21:32:27 GMT

you Need at least one ADMIN Role whioch should be yourself including your NTNAME (how you Login)

SECTION ACCESS:

load * inline [

ACCESS; ROLE, NTNAME, CONNECTFIELD2APP

ADMIN, ADMIN, DOMAIN\USER, *

USER, USER, DOMAIN\USER1, REG_US

USER, USER, DOMAIN\USER2, REG_EUR

Furthermore you should define under Documents Settings\Opening

Initial Data Reduction based on Section Access

When you run the script you will see everything. Only after save and reopen, Section Access will take place and work

Re: Section Access Help

hic — Thu, 19 Feb 2015 21:44:04 GMT

That is the purpose of Section Access... If you have a data reduction defined in Section Access, this will happen. Make sure that you have an entry option that doesn't reduce data.

ACCESS='ADMIN' + blank in the reducing field should do it.

HIC

Re: Section Access Help

Fri, 20 Feb 2015 07:45:35 GMT

Thanks Henric!!

Does it mean then that the reducing field has null values in it and hence the data displayed even for admin role is halved.

Re: Section Access Help

hic — Fri, 20 Feb 2015 08:31:46 GMT

It could be NULL - it could be blank. The point is, that if the reducing field has a value that doesn't exist in data, then this initial selection fails. QlikView will then do one of two things:

Deny access to the document (If USER and Strict Exclusion is on)
Show all data (If ADMIN or Strict Exclusion is off)

HIC

Re: Section Access Help

Anonymous — Fri, 20 Feb 2015 08:45:22 GMT

using "NOREDUCTION" in the reducing field for the admin should work as well

ADMIN, ADMIN, DOMAIN\ADMUSER, NOREDUCTION

Re: Section Access Help

Fri, 20 Feb 2015 09:05:18 GMT

So in my script, I am using the below code for loading the admin users.

AdminUsers:
MAPPING LOAD * INLINE
[
Username, Level
DOMAIN\ABC, ADMIN

DOMAIN\DEF, ADMIN

];

Then I am mapping this field with NTNAME to calculate ACCESS field.

Applymap('AdminUsers', Upper(NTNAME), 'USER') as [ACCESS]

How do I assign ADMIN+Blank in the reducing field?

Re: Section Access Help

Fri, 20 Feb 2015 09:18:50 GMT

Can you please help me with the syntax. Where should I be writing NOREDUCTION?

Re: Section Access Help

Fri, 20 Feb 2015 09:36:37 GMT

Would it work for multiple reducing fields?

Re: Section Access Help

hic — Fri, 20 Feb 2015 10:01:06 GMT

One way to do it is

Authorization:
Load
ACCESS,
NTNAME,
If(ACCESS='ADMIN', 'NOREDUCTION', REDUCTION) as REDUCTION
;
Load
Applymap('AdminUsers', Upper(NTNAME), 'USER') as ACCESS,
Upper(NTNAME) as NTNAME,
Upper(REDUCTION) as REDUCTION
From ...

For multiple reducing fields, you should read Data Reduction Using Multiple Fields.

HIC

Re: Section Access Help

Fri, 20 Feb 2015 10:26:54 GMT

In the statement If(ACCESS='ADMIN', 'NOREDUCTION', REDUCTION) as REDUCTION
is Reduction a field?

Re: Section Access Help

Fri, 20 Feb 2015 11:00:39 GMT

Hi Henric,

I am using the below script in section access.

UserEntitlementFinal:
NOCONCATENATE LOAD
ACCESS
, NTNAME
, if(IsNull(AB) or Len(Trim(AB))>0,'',AB) as AB
, if(IsNull(CD) or Len(Trim(CD))>0,'',CD) as CD
,RESIDENT UserEntitlement;
DROP TABLE UserEntitlement;

AB and CD are reducing fields.

Data is displayed properly in this case. But when I open the document with USER, the document fails to open. When I uncheck Strict Exclusion, it works fine. Is it correct?

Re: Section Access Help

hic — Fri, 20 Feb 2015 12:59:13 GMT

"REDUCTION" is the field that you want to use as reducing field, yes.

You need to have Strict Exclusion on. If it doesn't open, then it means that there is no combination of AB and CD that the user has the right to see.

I would advice against using multiple reducing fields, of the reasons that I explain in Data Reduction Using Multiple Fields.

HIC