Showing results for 
Search instead for 
Did you mean: 

EPM DIMENSION Override and Local Members

Active Participant
0 Kudos

Hello All,

I have the below scenario for which I am trying to find a workaround.

As per our EPM conversion logic, any cost centre that has the value 8 on the 3rd byte is mapped to the Business Function XXXX. As per this logic, the BPC load and everything are working as expected.

However, the business had come up with a request to get the mapping changed to the business function YYYY when the cost centres have 8 as its third letter so that the periodic values which are currently populated under Business Function XXXX is visible under YYYY.

As we do not want to go ahead and change the conversion logic at this moment, I am looking for a workaround.


Below Costcenters are currently mapped to Business Function XXXX.

Costcenters >> Business Function

AI8698523 >> XXXX

AI8698524 >> XXXX

AI8698525 >> XXXX

AI8698526 >> XXXX

Expected Result:

Costcenters >> Business Function

AI8698523 >> YYYY

AI8698524 >> YYYY

AI8698525 >> YYYY

AI8698526 >> YYYY

My understanding:

Option -1

I believe I can make use of EPM DIMENSION OVERRIDE function. However, as I need to deal with two different dimensions, I am not sure whether it would work.

Option - 2

Using the Local Members to handle the logic. But, I am not sure how to get this implemented in the user's report that has sheets with both dynamic and static nature.

Kindly share your thoughts on this.

I may not be able to share the screenshot of the user's reports over here so kindly bear me with me.

Referred Links:

Thanks, Vin.

Active Contributor
0 Kudos

Sorry, but your requirements are absolutely not clear!

If you want an answer, please spend some time to explain again with screenshots etc...

Accepted Solutions (0)

Answers (0)