Section Access Help

[#1]

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

[#2]

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

[#3]

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

[#4]

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

[Anonymous]

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

[hic]

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

[#7]

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.

[hic · Accepted solution]

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:

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

HIC

[Anonymous]

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

ADMIN, ADMIN, DOMAIN\ADMUSER, NOREDUCTION

[#10]

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?