How to use HidePrefix in an Inline.

[#1]

Hi,

I have some Inline table where I want to use HidePrefix in order to hide these feilds from being displayed in current selection box.

Any help will be highly appreciated.

For Eg: here I want to hide feild Alphabet from being displayed as I have always one value selected in this list box.

SET HidePrefix='~';

How_to:   

LOAD * Inline [

Alphabet as [~Alphabet],

A,

B,

C,

D

];

Regards

Sagar Gupta

[Anonymous · Accepted solution]

Sagar,

This is how it can be done:

SET HidePrefix='~';

How_to:   

LOAD * Inline [

~Alphabet,

A,

B,

C,

D

];

Regards,

Michael

[#3]

Thanks a lot

I was trying using alias name and it was not working.

Regards

Sagar Gupta

[#4]

Hi Michael/Sagar,

                          I have same kind of issue, am using Set HidePrefix like below and  i have drill down group(added number dimension in drill exp like

=If(NUMBER=1,GROUP1, If(NUMBER=2, If(Match(REGIONS, ABC,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 but real problem drill down is not worlking correctly. So how can we implement this.

Set HidePrefix='~';

NUMBER:
LOAD* INLINE[

~NUMBER

1

2

3

4

];