cancel
Showing results for 
Search instead for 
Did you mean: 

Selection of Entity dimension member based on WBS dimension member property

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

In some cell read the property of WBS dimension.

Then in the entity cell use formula as it's explained in my document

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

0 Kudos

Thanks Vadim. Resolved the requirement. Nice to have your reply.

Regards

KMG

Answers (0)