Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
Partner
Partner

Another Section Access Issue

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

Tags (2)
10 Replies
prieper
Honored Contributor II

Re: Another Section Access Issue

USERID or NTNAME?

Partner
Partner

Re: Another Section Access Issue

NTNAME

Partner
Partner

Re: Another Section Access Issue

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
Honored Contributor II

Re: Another Section Access Issue

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?

Partner
Partner

Re: Another Section Access Issue

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

Re: Another Section Access Issue

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

Partner
Partner

Re: Another Section Access Issue

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?





MVP
MVP

Re: Another Section Access Issue

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
Honored Contributor II

Re: Another Section Access Issue

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