Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
frinfo
New Contributor

Control access management console

Hi everyone,

i've a problem with a section access in my .qvw.

I create this section access in the script:

sub CaricaSectionAccess2


UtentiCapoAreaSA:

NoConcatenate

load Distinct

trim([Key Agente Riferimento Cliente]) as [Key Agente Riferimento Cliente SA],

trim([Key Agente Cliente Codice]) as [Key Agente Cliente Codice SA]

resident AgentiClienti

where [Key Agente Riferimento Cliente] <> '' and not isnull([Key Agente Riferimento Cliente]);


MapKeyAgenteNomeUtente:

mapping load

    trim(DITTA) & '-' & trim(CODICE_AGENTE) as [% Key MapKeyAgenteNomeUtente],

trim(UTENTE) as [% Value MapKeyAgenteNomeUtente]

FROM

Dati\utenti_ruoli.xls

(biff, embedded labels, table is utenti$);


Ruoli:

LOAD

     trim(RUOLO) as RUOLO,

     trim(PRINCIPALE) as PRINCIPALE,

     trim(VENDITE) as VENDITE,

     trim(ACQUISTI) as ACQUISTI,

     trim(ORDINICLIENTI) as ORDINICLIENTI,

     trim(ORDINIFORNITORI) as ORDINIFORNITORI,

     trim(BUDGET) as BUDGET,

     trim(AGENTI) as AGENTI,

     trim(MAGAZZINO) as MAGAZZINO,

     trim(PRODUZIONESEDE) as PRODUZIONESEDE,

     trim(REPORTDINAMICO) as REPORTDINAMICO,

     trim(DASHBOARD) as DASHBOARD,

     trim(SALES) as SALES

FROM

Dati\utenti_ruoli.xls

(biff, embedded labels, table is ruoli$);

section access;


Access:

LOAD * INLINE [

ACCESS,NTNAME,IDAGENTE,AZIENDAID,RUOLO

ADMIN,PIPPO\USER1,*,*,SUPERUSER

ADMIN,PIPPO\USER2,*,*,SUPERUSER

ADMIN,PIPPO\USER3,*,*,SUPERUSER

ADMIN,PIPPO\USER4,*,*,SUPERUSER

ADMIN,PIPPO\USER4,*,*,SUPERUSER

ADMIN,PIPPO\USER5,*,*,SUPERUSER

ADMIN,PIPPO\USER6,*,*,SUPERUSER

];

TabSA:

load Distinct

IDAGENTE as IDAGENTE_SA

resident AgentiClienti;

join (TabSA)

load Distinct

AZIENDAID as AZIENDAID_SA

Resident Aziende;

join (TabSA)

load Distinct

RUOLO as RUOLO_SA

Resident Ruoli;

Concatenate(Access)

load

'ADMIN' as ACCESS,

'PIPPO\USER1' as NTNAME,

IDAGENTE_SA as IDAGENTE,

AZIENDAID_SA as AZIENDAID,

//CODICEFAMIGLIAID_SA as CODICEFAMIGLIAID,

//CODGRUPPOSTATISTICO1ID_SA as CODGRUPPOSTATISTICO1ID,

RUOLO_SA as RUOLO

resident TabSA;

Concatenate(Access)

LOAD

     trim(TIPO_UTENTE) AS ACCESS,

     trim(UTENTE)      as NTNAME,

     if

     (

      len(trim(CODICE_AGENTE)) = 0,

      '*',

      trim(DITTA) & '-' & trim(CODICE_AGENTE)

     ) as IDAGENTE,

     if(len(trim(DITTA)) = 0,'*',trim(DITTA)) as AZIENDAID,

    

     //if(len(trim(CODICE_FAMIGLIA)) = 0,'*',trim(CODICE_FAMIGLIA) ) as CODICEFAMIGLIAID,

     //if(len(trim(CODICE_GRUPPO_STATISTICO1)) = 0,'*',trim(CODICE_GRUPPO_STATISTICO1)) as CODGRUPPOSTATISTICO1ID,

    

     trim(RUOLO)  as RUOLO

FROM

Dati\utenti_ruoli.xls

(biff, embedded labels, table is utenti$);

concatenate(Access)

load

'USER'   as ACCESS,

ApplyMap('MapKeyAgenteNomeUtente',[Key Agente Riferimento Cliente SA],'NOAG') as NTNAME,

[Key Agente Cliente Codice SA]   as IDAGENTE,

SubField(trim([Key Agente Riferimento Cliente SA]),'-',1)   as AZIENDAID,

//'*'   as CODICEFAMIGLIAID,

//'*'   as CODGRUPPOSTATISTICO1ID,

'AGENTE'   as RUOLO

resident UtentiCapoAreaSA

order by [Key Agente Riferimento Cliente SA]

;

section Application;

end sub


after i've publish the file in my WebServer and i make a reaload with administrator user in managment console.

i've set on the objects of my sheet the visibility trought an ACL based on user defined in the .xls, but every user can see all the objects.

What could it be the problem?

Thanks in advance.