Skip to Content
0

EPMDimensionOverride Output with Hierarchy Nodes & Base Members

May 08 at 11:40 AM

60

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin May 08 at 04:39 PM
0

What do you mean by:

ENTITY="&$A$6")

ENTITY - property?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Yes. It is a Property.

0
Vadim Kalinin May 09 at 08:06 AM
0

Look on this sample (test on environmentshell):

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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...

0
Vadim Kalinin May 09 at 09:26 AM
0

"both at parent and base level simultaneously"

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

may you mean ALL?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0