Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I add a section access to my document and when I open it with my qlik client it works perfectly.
It seems like I don't have data when I try to open from access point portal, in fact it returns me to userid/password screen...
Is there maybe some switch to set on management console?
(I set "Initial data reduction" and "Strict exclusion" to ON, if I set "Strict Exclusion" to OFF I enter...)
Some help?!
USERID or NTNAME?
NTNAME
Here my SA.
MyAdmin enter correctly using Qlikview Client, not in the web Portal (even if I add the DOMAIN name....):
LOAD * INLINE [
ACCESS, NTNAME, CODAGENTEPORT, DOCAGENTE
ADMIN, MYADMIN,*,*
USER, AAA,*,*
USER, BBB,*,*
USER, CCC,*,*
USER, DDD,*,*
USER, EEE,*,*
USER, FFF,*,*
USER, GGG,*,*
USER, HHH,*,*
USER, III,*,*
USER, JJJ,*,*
USER, KKK,*,*
USER, LLL,*,*
USER, MMM,*, C
USER, NNN,*, C
];
CONCATENATE
//============================================================================= AGENZIE
LOAD
'USER' AS ACCESS, UPPER(LOGIN) AS NTNAME, UPPER(CODAGENTE) AS CODAGENTEPORT, 'A' AS DOCAGENTE
FROM
[..\QVD\DOCAGE_A.qvd](qvd);
CONCATENATE
LOAD
'USER' AS ACCESS, UPPER(LOGIN_L2) AS NTNAME, UPPER(CODAGENTE) AS CODAGENTEPORT, 'C' AS DOCAGENTE
FROM
[..\QVD\DOCAGE_C.qvd](qvd);
];
Strange ....
Have you checked, what OSNAME() returns when opened locally and when opened from server?
Spelling is ok, in Capitals?
You are included as ADMIN?
The OSName() is exactly the same locally and on the portal (I uncheck the strict exclusion to see it)...
All is in Capitals, and yes I have the admin (or I can't open it in the client....)
Note that an asterisk in a Section Access link field will only expand to all values in that field in that Section Access table, not to all the field values in your entire data model.
For example I don't see any valid values for field CODAGENTEPORT, only stars...
All values are loaded in user concatenated after the first inline section
So I think it's like:
ACCESS, NTNAME, CODAGENTEPORT, DOCAGENTE
ADMIN, MYADMIN, *,*
USER,AAA,*,*
...
USER,NNN,*,*
USER,NAME1,A001,A
USER,NAME2,A002,C
USER,NAME3,A003,A
USER,NAME4,A004,C
...
So the ADMIN should take all CODAGENTEPORT listed in section access table and all DOCAGENTE (A and B) loaded after that
Isn't so?
I tried this script
SECTION Access;
LOAD * INLINE [
ACCESS, NTNAME, CODAGENTEPORT
ADMIN, domain\user, 1
ADMIN, domain\user, *
];
SECTION Application;
Y: LOAD rowno() as CODAGENTEPORT, 'num ' & rowno() as FIELD1 AutoGenerate 10;
SECTION Access;
LOAD * INLINE [
ACCESS, NTNAME, CODAGENTEPORT
USER, DUMMY, 3
USER, DUMMY, 4
USER, DUMMY, 5
ADMIN, domain\user, 6
];
I can see the CODAGENTPORT 1 3 4 5 6
Concatenate seems to work in section access
Concatenation works also in my scripts.
Think that the major problem is the "*", which considers only the values, which are loaded in the accesstable. If you only have "*" or the underlying data contain more entries, that in the Access-Table, users will not be able to see it.
Am therefore using a script like:
SECTION ACCESS;
STAR IS *;
AccessTable: LOAD DISTINCT 'DUMMY' AS ACCESS, MYFIELD RESIDENT .....;
CONCATENATE (AccessTable) LOAD ACCESS, NTNAME, MYFIELD FROM ....;
SECTION APPLICATION;
'DUMMY' or any other string than USER or ADMIN is ignored by QV.
The first part may also be replaced with a more performant script like
LOAD 'DUMMY' AS ACCESS, FIELDVALUE('MYFIELD', RECNO()) AS MYFIELD AUTOGENERATE FIELDVALUECOUNT('MYFIELD');
Peter