topic Re: Section Access Issue in QlikView

Section Access Issue

alec1982 — Fri, 07 Jun 2013 21:13:44 GMT

Hi Guys,

I have a section access set on a qvw as follow:

Section Access;

Star is *;

LOAD ACCESS,

UPPER(NTNAME) AS NTNAME,

%PROJECT_MANAGER,

%PROGRAM_MANAGER

FROM

[..\Excel Input\Security.xlsx]

(ooxml, embedded labels, table is Users);

Section Application;

ProjectManager:

LOAD distinct

Name as [Project Manager],

USERKEY as %PROJECT_MANAGER

FROM

[..\qvds\Processed Tables\SAUser.qvd](qvd);

ProgramManager:

LOAD distinct

Name as [Program Manager],

USERKEY as %PROGRAM_MANAGER

FROM

[..\qvds\Processed Tables\SAUser.qvd](qvd);

Now everything is working fine except one scenario: when I have a project and any of the Project manager or the Program Manager is not listed on the security excel file then this project doesn't show up on the qvw.. even I am logged in as Admin.

Anyway I can fix this.

Thxs,

Alec

Re: Section Access Issue

swuehl — Sat, 08 Jun 2013 10:33:38 GMT

Could you post a sample of your section access security table?

If you put a star * in the columns %PROJECT_MANAGER and %PROGRAM_MANAGER for user ADMIN, try with just a blank field value.

Re: Section Access Issue

alec1982 — Sat, 08 Jun 2013 15:22:53 GMT

Hi Swuehl,

Here is a sample of the security file:

ADMIN

NA\ATLHARFB

USER	SERVER99\MDAVI	MDAVI	MDAVI	*			1
ADMIN	SERVER99\NEXC	NBHAT	NBHAT	*			27

I didn't get what you mean by blanck field value.

Thxs so much for all your help.

Alec

Re: Section Access Issue

swuehl — Sat, 08 Jun 2013 16:52:16 GMT

I would try removing the star symbol '*' from columns %PROJECT_MANAGER and %PROGRAM_MANAGER, just leaving the field empty for the ADMIN line.

Re: Section Access Issue

alec1982 — Mon, 10 Jun 2013 20:47:19 GMT

Thxs for all your help!

Re: Section Access Issue

alec1982 — Thu, 13 Jun 2013 14:39:20 GMT

Hi Swuehl,

I noticed an issue happening when i do the space instead of the *

The names of the users from the security excel file appear on the Program manager and Project manager list boxes on the application..

for example, the the QV administrator User name which is used to reload the qvws appears on the list boxes while it is not part of any of the projects..

Any idea on what could be done wrong?

Thxs again for all your help!

Alec

Re: Section Access Issue

alec1982 — Fri, 14 Jun 2013 15:05:46 GMT

Hey guys,

Anybody has a solution for my issue 🙂

Thxs for all your help..

Alec

Re: Section Access Issue

Fri, 14 Jun 2013 17:27:33 GMT

Instead of using space, leave the filed empty for the ADMIN. An space is a value after all.

Re: Section Access Issue

alec1982 — Fri, 14 Jun 2013 17:59:15 GMT

Hi,

The fields are empty.

and assuming if they are taking a vlue of space then i should not see any of the data..

Thxs for all your help!

Alec

Re: Section Access Issue

Fri, 14 Jun 2013 18:20:17 GMT

Mmmm it will be hard to tell, but are ProjectManager and ProgramManager tables linked in the Data Model?

Re: Section Access Issue

alec1982 — Fri, 14 Jun 2013 18:26:09 GMT

Yes they are and the section access is working for the users ..

Re: Section Access Issue

Fri, 14 Jun 2013 19:14:03 GMT

I'm sorry but then I don't understand what's the problem if as you say this is working for users.

When you say that "The names of the users from the security excel file appear on the Program manager and Project manager list boxes on the application.." you mean that you're showing the fields [Project Manager] and [Program Manager], as Listbox objects and inside of them you get the NTNAME values from the section access table? or what am I getting wrong?

Re: Section Access Issue

Wed, 03 Jul 2013 14:06:26 GMT

Try not using % and similar chars. It might solve the issue.

Plus can you attach the application.

KR,

Milan

Re: Section Access Issue

Mon, 08 Jul 2013 14:07:44 GMT

Alec,

I double checked it, sadly that is the way it works - asteriks (*) provides you with data values only listed in Section Access. So if some data field value exists but is not listed in section access, you won't be able to see it.

(QlikView 11 for Developers - Chapter 14: Security / Reduction fields)

Hope it helps.

KR,

Milan