Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access in QEMC

1. How to implement section access in QEMC 9.0 ?

2. What is the Usage of Section Access mentioned under QEMC -> sETUP - > Advanced tab.

5 Replies
Miguel_Angel_Baeyens

Hi,

1. Section access is always at a document level, meaning you code it in the document script, and meaning that you may have two documents with different section access. Search a bit in the forums and you will find several dozens of posts and sample codes covering the different fields and ways to get the section access working.

2. I don't have such setting. What version are you using? Can you please elaborate on how to get to that "Advanced" tab?

Regards.

Not applicable
Author

For point 2, can I say that you use QV Publisher?

The difference is you can hv centralized section access and you can reuse it for other files

Not applicable
Author

hi,

you may define a section access in your script as

Section access;

Acces_table:

ACCESS, USERID, [PASSWORD, FIELD1, FIELD2...]
Admin, Name, [pwd, Dept, field...]
User, Name, [pwd, Dept, field...]

you can ever load it from a table or a file as

LOAD DISTINCT
'USER' as ACCESS,
Name as USERID,
Pass as PASSWORD,
Dept_name as DEPT
...

RESIDENT Table

Don't forget to save a copy beifre loading in case you messed up the content of this section, you wouldn't be able to open it again!!

open the your section application and get relation with access table

section application;

star is *;

Reduc_Data_table:
load * inline [
DEPT, Territorycode
0, *
];
LOAD
Territorycode as DEPT,
Territorycode
RESIDENT Terr_Table;

this will give all access to DEPT = 0 and reduce date to other accordiing value of DEPT.

Tick the option "Data reduction based on section access" in "Setting, opening"

regards

christian

Not applicable
Author

Thanks for your reply.

I wanted to clarify the Section Access mentioned in QEMC in the following tab:

System -> Setup -> Distribution Services -> Advanced Tab -> Section Access

Not applicable
Author

I am sending a pdf attached with that reply...

May be it will help you..

Thanks & Regards,

Deep