on 11-03-2015 1:30 PM
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
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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.