Section Access Issue

[alec1982]

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

[swuehl · Accepted solution]

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.

[alec1982]

Hi Swuehl,

Here is a sample of the security file:

ADMIN

NA\ATLHARFB

*

*

*

1

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

[swuehl]

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

[alec1982]

Thxs for all your help!

[alec1982]

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

[alec1982]

Hey guys,

Anybody has a solution for my issue 🙂

Thxs for all your help..

Alec

[#8]

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

[alec1982]

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

[#10]

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