EPM Dimension overrride - Hierarchy view

[bhagyesh_ravange]

Hi All,

I want to display Hierarchy structure in row based on the selection given.

Selection:

1) Base Member only ( i.e. if member "C" is selected the only T,U,V,W,X,Y is to be displayed)

2) Member & Base level ( i.e. if member "C" is selected the member C along with T,U,V,W,X,Y is to be displayed)

3) Member & Descendants ( i.e. Member c and all the members below C is to be displayed.)

For the Base member formula given is =EPMDimensionOverride("000","PROFITCENTER",BAS(C) AND PROP_1=Y).

For the Member & Base level formula given is =EPMDimensionOverride("000","PROFITCENTER",C OR BAS(C) AND PROP_1=Y).

I would require the same for the Member & Descendants. Please correct me if I am wrong.

Thanks & Regards

Bhagyesh

[former_member186338 · Accepted solution]

But what is the issue?

=EPMDimensionOverride("000","PROFITCENTER",C OR ALL(C) AND PROP_1=Y)

Please read help: 33.8.1 EPMDimensionOverride

[bhagyesh_ravange · Accepted solution]

Hi Vadim,

Thanks for you prompt reply.

I also want Intermediate Members also to be displayed i.e. 1,2,3,4,5,6.

Regards

Bhagyesh Ravange

[former_member186338 · Accepted solution]

ALL will show all descendants of C, including "Intermediate Members". Please, read help!