Section access on Multiple Dimensions

[#1]

Hi ,

Currently i have section access on one dimension called Department but i want to put filter on another dimension called Region,how can i incorporate that into the below code.Thanks.

section access;
LOAD
     UPPER(ACCESS) as ACCESS,

     UPPER(USERID) as USERID,

     UPPER(REDUCTION) as REDUCTION

inline [

ACCESS, USERID, REDUCTION
USER,DOMAIN\SJANARDHAN,D1550
USER,DOMAIN\VKALLURI,D1500

];

[Chanty4u]

try this

Section Access with multiple Dimensions

[SunilChauhan]

SEE THE EXAMPLE BELOW

admin have all dept and region access

user has their own dept and region link to it.

SECTION ACCESS;

Load * Inline [

ACCESS,USERID,DEPT

ADMIN,SUNIL,*

USER,AMIT,IT

USER,SMIT,APP

USER,AJIT,SUPPORT

USER,AJAY,NEW

];

SECTION Application;

lOAD * INLINE [

DEPT,REGION

IT,EAST

APP,WEST

SUPPORT,NORTH

NEW,SOUTH

];