Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to use section access but I don't succeed. I have a simple doc where I use an inline table adding ACCES, NTNAME and DEPARTMENT fields. It is supposed to login automatically recognizing the domain and username and do a reduction by DEPARTMENT.
The thing is that it works when I filter for a specific department, but it doesn't when I try to use the *. It is supposed that using the * and adding other values on the same column (DEPARTMENT in my case) * should represent all listed values. But when I use it it doesn't allow me to open the doc.
I am really stucked on it and I can't find why it is not working as other examples I've found, this one for exampleQlikView Section Access Examples
That's the script I use. Many thanks in advance.
DEP:
load* Inline
[Name, DEPARTMENT
A,ABC
B,XYZ
C,BNH
D,JHK
E,LKJ
F,OLP
];
section_access:
load * inline [
ACCESS, NTNAME, DEPARTMENT
USER, domain\RUBEN.GRAU, *
USER, domain\someone, ABC
];
STAR is *;
SECTION ACCESS;
LOAD
ACCESS,
NTNAME,
DEPARTMENT
RESIDENT section_access;
SECTION APPLICATION;
STAR is;
* should represent all listed values
That's right and in the below table only ABC is listed:
sectionaccess_tmp:
load * inline [
ACCESS, NTNAME, DEPARTMENT
USER, domain\RUBEN.GRAU, *
USER, domain\someone, ABC
];
So RUBEN.GRAU will only have access to department ABC
* should represent all listed values
That's right and in the below table only ABC is listed:
sectionaccess_tmp:
load * inline [
ACCESS, NTNAME, DEPARTMENT
USER, domain\RUBEN.GRAU, *
USER, domain\someone, ABC
];
So RUBEN.GRAU will only have access to department ABC
PSA.
hope that helps.
Use below Ids and pswrds to see their respective data.
ACCESS ,NAME ,PASSWORD ,DEPARTMENT
ADMIN ,RUBEN.GRAU ,RUBEN.GRAU , *
USER ,A ,A , ABC
USER ,B ,B , XYZ
USER ,SOMEONE ,SOMEONE , *
Thanks
in my test it works (*) but not with section access loaded from resident
DEP:
load* Inline
[Name, DEPARTMENT
A,ABC
B,XYZ
C,BNH
D,JHK
E,LKJ
F,OLP
];
//section_access:
//load * inline [
//ACCESS, NTNAME, DEPARTMENT
//USER, domain\RUBEN.GRAU, *
//USER, domain\someone, ABC
//USER, mydomain\myuser, ABC
//];
SECTION ACCESS;
//STAR is *;
load * inline [
ACCESS, NTNAME, DEPARTMENT
USER, domain\RUBEN.GRAU, *
USER, domain\someone, ABC
USER, domain\someone2, XYZ
USER, mydomain\myuser, *
];
//LOAD
// ACCESS,
// NTNAME,
// DEPARTMENT
//RESIDENT section_access;
SECTION APPLICATION;
//STAR is;
i guess domain\RUBEN.GRAU should be included in the 'Name' field.
if we include it, * works fine.
Please see the script in my qvw attached earlier.
If your user gets access denied, you probably have strict exclusion enabled.
I think what's missing is a
drop table section_access;
at the end of your script. If you don't drop the table, you will get into troubles on opening.