Section Access using Excel for Reduction

[bnichol]

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,

B

[#2 · Accepted solution]

Hi,

You need to declar:

STAR IS *;

[bnichol]

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,

B

[#4]

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.

[garystrader]

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