Skip to Content

BPC Dimensions and Properties in EPM reports

Hi experts,

I am creating an input schedule where I want to put several dimensions in the row axis. I have 2 dimensions, PROJECT and FUNCTION, which have a one to many relationship. 1 FUNCTION is linked to many PROJECTS. I have therefore created FUNCTION as a property of PROJECT.

My requirement is when I select FUNCTION, the input/report should show all the PROJECT members associated with that FUNCTION in the rows.

Please help me achieve this

Regards

Jordan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 10 at 09:57 PM

    For multiple FUNCTIONS look on my example:

    I have COMPANY_CODE and COST_CENTER with a property BPC_COMPANY_CODE

    First I create report with both COMPANY_CODE and COST_CENTER in row axis.

    Then in member selector for COMPANY code I use:

    And with EPMDimensionOverride I have report for 2 COMPANY_CODE members:

    You can use Excel formulas to create the override condition like: "BPC_COMPANY_CODE=CO_BR00 OR BPC_COMPANY_CODE=CO_AU00"

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10 at 08:45 PM

    Easy:

    If you need to select only one function then you can use EPMDimensionOverride to override PROJECT dimension using FUNCTION property.

    If you want to select multiple functions then you can establish relation between function and project in the function member selector (function = property function of project). Also use EPMDimensionOverride to override PROJECT dimension using FUNCTION property (multiple properties).

    Add comment
    10|10000 characters needed characters exceeded

    • EPMContextMember will select only single FUNCTION :)

      Let's assume you have in A1

      =EPMContextMember(,"FUNCTION",,TRUE)

      to select single FUNCTION member.

      Then in A2 write (for default report 000):

      =EPMDimensionOverride("000","PROJECT","FUNCTION="&$A$1)

  • avatar image
    Former Member
    Jan 10 at 08:57 PM

    Hi Jordan

    Function can be given as selection in the context depending on the function selected Epmdimensionoverride for PROJECT will display many projects which are relavent to that function.

    Example:

    If Function is given as selection in c9 cell as =epmcontextmember(,Function)

    if selection is Function1

    Selected member in this case Function1 should be passed to dimension override function as below

    =EPMDimensionOverride("000","PROJECT","'$C$9'")

    Row axis will be filtered by Function1 relavent projects.

    Other way:

    This can also be done using linking Function property to PROJECT dimension.

    Hope this helps for your requirement. Thank you

    Regards,

    Durgaprasadh

    Add comment
    10|10000 characters needed characters exceeded