Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,,
I have a problem with Set HidePrefix with drill down group, am using Set HidePrefix like below and i have a drill down group(added number dimension in drill exp like =If(NUMBER=1,GROUP1, If(NUMBER=2, If(Match(REGIONS, AMC,DEF, GHI,JKL), REGIONS)))
) in my app so if we use the drill down group in any chart then Number is getiing hiden from Current Selection Box by using below script but real problem is drill down is not worlking correctly. So how can we implement this.
Set HidePrefix='~';
NUMBER:
LOAD* INLINE[
~NUMBER
1
2
3
4
];
Hi Anil, what if you has both fields aviable!?
In the drill down group you use NUMBER ant in listboxes you use ~NUMBER.
The only way to choose NUMBER is through the drill down group...
LOAD* INLINE[
~NUMBER, NUMBER
1, 1
2, 2
3, 3
4, 4
];
/A