Hi
I used this code to create a QVD for the section access
original:
LOAD
USERID,
DIMENSION,
VALOR
FROM
[..\XLSX\SEGURIDAD.xls]
(biff, embedded labels, table is Nuevo$);
Temp1:
Generic load * resident original;
result:
load distinct USERID resident original;
drop table original;
FOR i = 0 to NoOfTables()
TableList:
LOAD TableName($(i)) as Tablename AUTOGENERATE 1
WHERE WildMatch(TableName($(i)), 'temp1.*');
NEXT i
FOR i = 1 to FieldValueCount('Tablename')
LET vTable = FieldValue('Tablename', $(i));
LEFT JOIN (result) LOAD * RESIDENT $(vTable);
DROP TABLE $(vTable);
NEXT i
drop table TableList;
LEFT JOIN
LOAD ACCESS,
USERID,
PASSWORD,
TABLERO
FROM
[..\XLSX\SEGURIDAD.xls]
(biff, embedded labels, table is Nuevo$);
NoConcatenate
Seguridad:
LOAD
USERID,
if( IsNull (NEGOCIO), '*', NEGOCIO) AS NEGOCIO,
if( IsNull (MERCADO), '*', MERCADO) AS MERCADO,
PASSWORD,
ACCESS,
TABLERO
resident result;
DROP TABLE result;
the result, for example, is
ACCESS | USERID | PASSWORD | MARKET | BUSINESS | TABLERO |
ADMIN | ADMIN | A | * | * | T |
USER | EDUARDO | A | * | 1 | T |
USER | JEREMIAS | A | 2 | * | T |
MARKET and BUSINESS are the fields that i wanna hide (or don't hide) to the users.
Now. The problem is that i don't know why, this isn't working.
For example, with the admin user, i can't see all the market and business. I only see Business = 1, and MARKET = 2
And with the other users i can only see MARKET = 2, and BUSINESS = 1.
Do you now why?
Thank you, Greetings.