Hi,
in my personell_app, I would like to introduce something new:
- There should be names, but
- ONLY for the HR department and myself
=> For all other users, the names should not be loaded into the DataModel.
=> In principle, this should be easy: In my SA (which I construct from two parts, a short inline_table and a LOAD from an excel file), I have introduced a new field, OMIT.
=> As I have eight name_fields (I had to work with alias names a few times to avoid synthetic keys), every user has eight lines in the
Excel field.
<=> It works but for the OMIT fields - those remain visible. I have only tested with one user (from the Excel list) and one chart (that is, two name_fields), but those are visible.
Can anybody tell me what I'm doing wrong here?`
I paste here the code for both parts of the SA. There must be something wrong there.
Oh - I have checked that "restrict data based on ..." in the document_properties, and the one below ("restrictive mode") too.
SA_temp:
LOAD * INLINE [
ACCESS, NTNAME, OMIT
ADMIN, [domain]\friedrich.hofmann,
USER, [domain]\SYNCREON\rgb1.hr,
];
// Zunächst werden hier alle anderen User aus einer Excel-Liste angehängt
Concatenate
LOAD
ACCESS,
NTNAME,
OMIT
FROM
[Users_with_limited_access_rights_b.xls
(biff, embedded labels, table is [Sheet1$]);
// Jetzt können wir diese Gesamttabelle RESIDENT laden und für den SA verwenden
Section Access;
LOAD
ACCESS,
NTNAME,
OMIT
RESIDENT SA_temp
;
DROP TABLE SA_temp;
(attached is the Excel file for the second part of the SA)
Thanks a lot!
Best regards,
DataNibbler
