Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try a calculated dimension: =if(field<>2,field)
Try something like this..
In List box, Add an expression instead of field.. If(MBR<>'2',MBR)
Hi,
if(match(field,'2')=0,field)
regards
Harshita Gaur
you can also use Valuelist('1','4','3')
Hi,
try this
if(not match(member,2),field)
thanks all that worked
Close the thread..
how
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.