Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
I would try removing the star symbol '*' from columns %PROJECT_MANAGER and %PROGRAM_MANAGER, just leaving the field empty for the ADMIN line.
Thxs for all your help!
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
Hey guys,
Anybody has a solution for my issue 🙂
Thxs for all your help..
Alec
Instead of using space, leave the filed empty for the ADMIN. An space is a value after all.
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
Mmmm it will be hard to tell, but are ProjectManager and ProgramManager tables linked in the Data Model?