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.
Vadim Kalinin replied
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: