Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.



Former Member

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



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")

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question