Section access Issue

rathnam_qv — Tue, 30 Aug 2016 14:11:00 GMT

Hi All,

PFA

i have implemented section access in qlik server.

it applying security but the issue is along with the region on which i applied security remaining also coming as grayed values in the filter.

can anyone help on this.

Thanks,

Muni.

Re: Section access Issue

vinieme12 — Tue, 30 Aug 2016 15:31:32 GMT

please post your section access script

Re: Section access Issue

rathnam_qv — Wed, 31 Aug 2016 01:56:01 GMT

Hi Vineeth,

Thsnk u for your response.

i am using Excel.

PFB code

Security:

LOAD

"ACCESS",

"USERID",

"USER NAME",

Q01A_BUSINESS_REGION_NAME,

Q01B_BUSINESS_REGION_NAME,

Q01C_BUSINESS_REGION_NAME,

Q01V_BUSINESS_REGION_NAME,

Q02_BUSINESS_REGION_NAME,

Q03_BUSINESS_REGION_NAME,

Q05_BUSINESS_REGION_NAME,

Q06_BUSINESS_REGION_NAME,

Q061_BUSINESS_REGION_NAME,

Q08_BUSINESS_REGION,

Q09_BUSINESS_REGION,

Q10_BUSINESS_REGION_NAME,

Q11_GLOBAL_REGION,

Q14_BUSINESS_REGION_NAME,

Q15_BUSINESS_REGION_NAME,

Q16_BUSINESS_REGION_NAME,

Q21_REGION

FROM [lib://Files/EP_EMEA_SECTION_ACCESS.xlsx]

(ooxml, embedded labels, table is SectionAccess_Admin);

Concatenate(Security)

LOAD

"ACCESS",

"USERID",

"USER NAME",

Q01A_BUSINESS_REGION_NAME,

Q01B_BUSINESS_REGION_NAME,

Q01C_BUSINESS_REGION_NAME,

Q01V_BUSINESS_REGION_NAME,

Q02_BUSINESS_REGION_NAME,

Q03_BUSINESS_REGION_NAME,

Q05_BUSINESS_REGION_NAME,

Q06_BUSINESS_REGION_NAME,

Q061_BUSINESS_REGION_NAME,

Q08_BUSINESS_REGION,

Q09_BUSINESS_REGION,

Q10_BUSINESS_REGION_NAME,

Q11_GLOBAL_REGION,

Q14_BUSINESS_REGION_NAME,

Q15_BUSINESS_REGION_NAME,

Q16_BUSINESS_REGION_NAME,

Q21_REGION

FROM [lib://Files/EP_EMEA_SECTION_ACCESS.xlsx]

(ooxml, embedded labels, table is SectionAccess_User);

Section Access;

LOAD

"ACCESS",

"USERID",

"USER NAME",

Q01A_BUSINESS_REGION_NAME,

Q01B_BUSINESS_REGION_NAME,

Q01C_BUSINESS_REGION_NAME,

Q01V_BUSINESS_REGION_NAME,

Q02_BUSINESS_REGION_NAME,

Q03_BUSINESS_REGION_NAME,

Q05_BUSINESS_REGION_NAME,

Q06_BUSINESS_REGION_NAME,

Q061_BUSINESS_REGION_NAME,

Q08_BUSINESS_REGION,

Q09_BUSINESS_REGION,

Q10_BUSINESS_REGION_NAME,

Q11_GLOBAL_REGION,

Q14_BUSINESS_REGION_NAME,

Q15_BUSINESS_REGION_NAME,

Q16_BUSINESS_REGION_NAME,

Q21_REGION

Resident Security;

Section Application;

Star is '*';

//drop Table Security;

Thanks,

Muni

topic Re: Section access Issue in App Development

Section access Issue

Re: Section access Issue

Re: Section access Issue