Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to create a Drill down where First column will have only single value followed by next dimensions having multiple values.
1st FieldName: Division value - GLOBAL
2nd FieldName: REGION - 7 Values for REGION
3rd FieldName: COUNTRY - Multiple values
Hence to show the column Division as 1st column in dimensional Drill down,
I concatenate null() as Division and appended it with the existing table.
It works fine but if I apply section access, it skips and moves automatically to 2nd Field - REGION.
Section Access is based on Region Level.
Any solution to achieve this with section access ?
Thank you !
Assign some Dummy value to Division , Region, Country for that null row.
In Section Access allow that Dummy row to be visible to all.
Section access;
Load * INLINE [
ACCESS, USERID, Region
USER, AD_DOMAIN\1, *
DUMMY,DUMMY,DUMMY
];
Section Application;
LOAD * INLINE [
USER, Region, Country
1,USA, ABC,
1, USA, XYZ,
1, AUS, PQR
1, IND, FGH
1, USA, ERT
1,RSA, TYU
1, SL, FGG
1, BAN, ERT
DUMMY,DUMMY,DUMMY
];
Hello,
Thank you for the response.
But if I do the same, I will be getting DUMMY as a value in REGION field in the front end.
Thank you!
Dummy Value is just for displaying data in drill down on applying section access in script;
could try out if((USER)='Dummy','',USER) in drill down expression to hide Dummy data.