Skip to Content

EPMDimensionOverride Output with Hierarchy Nodes & Base Members

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 08 at 04:39 PM

    What do you mean by:

    ENTITY="&$A$6")

    ENTITY - property?

    Add comment
    10|10000 characters needed characters exceeded

  • May 09 at 08:06 AM

    Look on this sample (test on environmentshell):

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

    Add comment
    10|10000 characters needed 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...

  • May 09 at 09:26 AM

    "both at parent and base level simultaneously"

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

    may you mean ALL?

    Add comment
    10|10000 characters needed characters exceeded