Skip to Content
0
May 30, 2016 at 05:23 PM

BPC NW 10 SP12 EPM Override codification to select tthe children

21 Views

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