Hiearchy Nodes

[Former Member]

Hi,

I have hierarchy where i want the report to automatically display the children of children

The nodes are      A      -> B
                                   -> C     -> D

                                   -> E     -> F

                                              -> G

So I want to be able to select "A" and D, F, G nodes (un expanded) should be displayed in the report

Added Node H          A      -> B
                                   -> C     -> D

                                   -> E     -> F

                                              -> G

                                   -> H     -> J

So for example if I added node H with the chilld J then J would automatically shown in the report. i.e. D, F, G, J would be displayed.

Any ideas if this is possible?

Cheers,

[former_member186338 · Accepted solution]

Hi Leo,

LDEP(LEVEL,PARENT_MEMBER,Y)

Where LEVEL is the level you want to show descendents of PARENT_MEMBER and Y - show only this level.

Use it in EPMDimensionOverride

Vadim

[former_member186338 · Accepted solution]

P.S. Or you can do the same using row axis Member Selector:

Vadim

P.S. Same result as with:

=EPMDimensionOverride("000";"INACCT";"LDEP(5,0,Y)")

Message was edited by: Vadim Kalinin - P.S. Added