BPC NW 10 SP12 EPM Override codification to select tthe children

[wissler_bastien]

Hi,

I have the dimension ACCOUNT.

I created the hierarchy of this dimension ACCOUNT

The node 'BS' (balance sheet) of this hierarchy has the following members:

ACCOUNT1

ACCOUNT2

ACCOUNT3

I created the report in EPM Excel and in edit report, we selected all accounts in column

In cell C2, we selected the  node of hierarchy account : BS in order to limited the account1, acount2 account3

I added the EPM fonctions : EPMDimensionOverride("000";"ACCOUNT"; C2)

the result of this function is correct but I would like to display the children (account1, acount2 account3) and not the node BS

I tried to use the DEP but it's a error

Can you help me to change the codification of this function EPMDimensionOverride

Thanks

Bastien

[former_member186338 · Accepted solution]

The correct syntax is:

=EPMDimensionOverride("000";"INACCT";"DEP(1)")

where 1 is member ID

Vadim

In your case:

=EPMDimensionOverride("000";"ACCOUNT";"DEP(BS)")

or

=EPMDimensionOverride("000";"ACCOUNT";"DEP("&C2&")")

C2 contains: BS

[wissler_bastien · Accepted solution]

Hi Vadim,

It's works, thanks