topic Section Access using Excel for Reduction in QlikView

Section Access using Excel for Reduction

bnichol — Mon, 27 Feb 2012 18:39:07 GMT

I'm trying to recreate the following example, but maintaining the section access entires in an excel spreadsheet...

Section Access;

LOAD * INLINE [

ACCESS, USERID, REGION

ADMIN, ADMIN1,

USER, USER1, AFRICA

USER, USER2, AMERICA

USER, USER3, ASIA

USER, USER4, EUROPE

USER, USER5, *

];

Section Application;

I'm having difficulty generating the entry for USER5, since they need access to all regions.

Is there a way to grant section access to * using a method other than the INLINE example I provided?

Any suggestions would be appreciated,

Section Access using Excel for Reduction

Mon, 27 Feb 2012 20:04:19 GMT

Hi,

You need to declar:

STAR IS *;

Section Access using Excel for Reduction

bnichol — Mon, 27 Feb 2012 20:08:52 GMT

Did you have a suggestion for the question...

Is there a way to grant section access to * using a method other than the INLINE example I provided?

Thanks,

Section Access using Excel for Reduction

Mon, 27 Feb 2012 20:29:36 GMT

Hi.

If i understand you're question,

You can use GROUP and the in the excel sheet declar for each GROUP the level of Security,

Section Access;

LOAD * INLINE [

ACCESS, USERID, GROUP

ADMIN, ADMIN1,

USER, USER1, AFRICA

USER, USER2, AMERICA

USER, USER3, ASIA

USER, USER4, EUROPE

USER, USER5, ALL

];

Section Application;

STAR IS *;

LOAD GROUP,

GROUP,

VALID

FROM

Security.xlsx

(ooxml, embedded labels, table is [Sheets]);

And then iin th excel:

GROUP	VALID
ALL	*
AFRICA	AFRICA
AMERICA	AMERICA

Hope it help.

Section Access using Excel for Reduction

garystrader — Mon, 27 Feb 2012 20:52:07 GMT

The section access table itself can also be pulled from Excel.