Skip to Content

Selection of Entity dimension member based on WBS dimension member property

Hi BPC Gurus,

     I have to make my Entity dimension member selected based on WBS dimension. In WBS Dimension we have property by "ENTITY" wherein all the WBS is mapped to Profit Center or Cost Center.

    This can be achieved if WBS and Entity were in the same axis i.e. using the Dimension Property in the member selector. but in my case the WBS is in the selection area where in the users will select based on their authorisation. Please find the image attached of what I am trying to get. Currently I am not finding a way on how to override the entity dimension based on WBS member property.

     Awating for your sharp and quick answers.

Regards

KMG

Capture.PNG (25.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 03, 2015 at 02:19 PM

    In some cell read the property of WBS dimension.

    Then in the entity cell use formula as it's explained in my document Static report in BPC NW 10

    Vadim

    P.S.

    In $A$4 you have WBS member

    In $B$8 you have ENTITY property:

    =EPMMemberProperty(; EPMMemberID($A$4); "ENTITY")

    In the ENTITY page axis member cell:

    = EPMOlapMemberO($B$8,"[ENTITY].[PARENTH1].[xxxx]","xxxxxxxxxxx";"";"000")

    Add comment
    10|10000 characters needed characters exceeded