Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to provide Section Access with multiple fields as below. This is the user access list. How can this be done using the section access?
field
field1 | field2 | field 3 | User | Header 5 |
---|---|---|---|---|
sla1 | legacy | mpt | user1 | |
sla2 | legacy | mpt | user1 | |
sla3 | sap crm | rms | user1 | |
sla4 | go solution | rms | user2 | |
sla5 | orda | rms | user2 | |
sla6 | orda | mhs | user2 | |
sla8 | mdiv | mhs | user2 | |
sla9 | siebel | mpt | user3 |
read this, it should help
http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization
Hola Anita tienes que realizar algo como lo siguiente:
//*******************************************************************************************
//Seguridad por Pestaña
Section Access;
SATABLE:
LOAD ACCESS,
NTNAME,
SAUSER
FROM
..\Include\Seguridad_Acceso_Hojas_Manufactura.xlsx
(ooxml, embedded labels, table is ListaUsuarios);
Section Application;
star is *;
LOAD SAUSER,
CTE,
CTI,
CTT,
CV,
ManoObraDirecta,
ManoObraTotal,
EficienciaMecanica,
UsodeCapacidad,
RendimientodeInsumos,
EjecutadovsProgramadoEmbotellado,
[Calidad(ProductoNoDefectuoso)Inyeccion],
[Calidad(ProductoNoDefectuoso)Tapas],
AccidentabilidadPlantaEmbotellado,
UtilizaciondeEnergiaElectricaEmbotellado,
CostodelMantenimiento,
UtilizaciondeAguaCrudaEmbotellado,
AseguramientodelaCalidad,
RotaciondeInventariosRefacciones
FROM
..\Include\Seguridad_Acceso_Hojas_Manufactura.xlsx
(ooxml, embedded labels, table is ListaUsuarios);
//*******************************************************************************************
ACCESS | NTNAME | SAUSER | CTE | CTI | CTT | CV | ManoObraDirecta | ManoObraTotal | EficienciaMecanica | UsodeCapacidad | RendimientodeInsumos | EjecutadovsProgramadoEmbotellado | Calidad(ProductoNoDefectuoso)Inyeccion | Calidad(ProductoNoDefectuoso)Tapas | AccidentabilidadPlantaEmbotellado | UtilizaciondeEnergiaElectricaEmbotellado | CostodelMantenimiento | UtilizaciondeAguaCrudaEmbotellado | AseguramientodelaCalidad | RotaciondeInventariosRefacciones |
ADMIN | AJEGROUP\PE3DEV1 | AJEGROUP\PE3DEV1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
ADMIN | AJEGROUP\PE3DEV8 | AJEGROUP\PE3DEV8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
ADMIN | AJEGROUP\QVSERVER | AJEGROUP\QVSERVER | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Espero te pueda ayudar.
Unfortunately I dont understand Spanish dear... but I am trying my best to understand the concept from what you have written.. Really appreciate your help.
The post from HC pubished by Massimo is the way to go! I had a similar issue some time ago and the method described by Henric it's the best I've found so far.