Skip to Content
0
May 08, 2018 at 11:40 AM

EPMDimensionOverride Output with Hierarchy Nodes & Base Members

444 Views

Hello Experts,

I need help on EPMDimensionOverride Function.

Scenario -1:

Formula using DEP:

=EPMDimensionOverride("000","P_DETAIL_SYNERGY","DEP(ADM_BLDG),ENTITY="&$A$6)

Output at parent level:

Scenario - 2:

Formula Using BAS:

=EPMDimensionOverride("000","P_DETAIL_SYNERGY","BAS(ADM_BLDG),ENTITY="&$A$6)

Output at Base Level:

Requirement: Our requirement is to get data with both at parent and base level simultaneously.

Please Suggest.

Thanks,

Karan

Attachments

bas-base-level.jpg (65.7 kB)