EPMDimensionOverride Output with Hierarchy Nodes & Base Members

[karan_kothari2]

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

[former_member186338]

"both at parent and base level simultaneously"

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

may you mean ALL?

[karan_kothari2]

Hi Vadim,

Apology for delay in respond.

Your formulation and logic is correct but the same is not fitting in my scenario (Multiple values needs to be fetched in ENTITY property).

I have tried in another way below mentioned and it is working as per the requirement (With "DEP" itself.

Where cell A7 refers to concatenation of another report range which is dynamic (at base level) as per the selection of parent level.

Thanks for all the help.

Thanks,

karan

[former_member186338]

Sorry, but your requirements are still not clear for me and the screenshot is missing...

[former_member186338]

Look on this sample (test on environmentshell):

=EPMDimensionOverride("000","ACCOUNT","PL300,DEP(PL300);ACCTYPE=INC")

[former_member186338]

P.S.

"Requirement: Our requirement is to get data with both at parent and base level simultaneously." - may be I don't understand your requirements...

[former_member186338]

What do you mean by:

ENTITY="&$A$6")

ENTITY - property?

[karan_kothari2]

Yes. It is a Property.