Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
datanibbler
Esteemed Contributor

SECTION_ACCESS with OMIT fields


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

Tags (1)
Community Browser