Another Section Access Issue

[Marcoimp]

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?!

[prieper]

USERID or NTNAME?

[Marcoimp]

NTNAME

[Marcoimp]

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);

];

[prieper]

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?

[Marcoimp]

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....)

[Peter_Cammaert]

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...

[Marcoimp]

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?

[maxgro]

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

[prieper]

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