removing member from dimension

[#1]

Hi

How can i not show a member in dimension, so in the example below i do not want to show 2.

1

2

3

4

[jpenuliar]

try a calculated dimension: =if(field<>2,field)

[PradeepReddy]

Try something like this..

In List box, Add an expression instead of field..  If(MBR<>'2',MBR)

[#4]

Hi,

if(match(field,'2')=0,field)

regards

Harshita Gaur

[jpenuliar]

you can also use Valuelist('1','4','3')

[#6]

Hi,

try this

if(not match(member,2),field)

[#7]

thanks all that worked

[PradeepReddy]

Close the thread..

[#9]

how

[jagan]

Hi,

Try this calculated dimension

=If(DimensionName<>2,DimensionName)

Or

The best approach handle this in script, calc dimensions has performance issues.

LOAD

*,

If(DimensionName<>2,DimensionName) AS NewDimensionName

FROM DataSource;

Now use NewDimensionName as dimension.

Regards,

Jagan.