How to do in EPM dimension override with a dinamic link to another dimension

[manuel_medina1]

Hello expert,

Hope you can help me with this doubt in EPM Reporting in BPC Classic.

The situation is the following:

There is a sample report, with TIme dim in rows and Currency in columns. In the top of the report there is a select list with two options. If the User select B the Currency should be overriden with member "EUR" That parts works with the standard epmdimensioverride:

select-list.png

=+EPMDimensionOverride("000";"RPTCURRENCY";"EUR")option-b.png

The other option, when the user select option B, the requirement is to make a dinamic selection linking the ID of the Currency with the property Currency of the Entity selected in Context.

So the question is, how with EPM formulas can I set in Report Columns dimension this dinamic selection linked to Entity's Currency Property.

option-a.png

I tried establishing the condition with the following sentence without sucess:

=+EPMDimensionOverride("000";"RPTCURRENCY";"Linked to property 'CURRENCY' of Dimension 'ENTITY'")

I Know this same requirement could be achieved obtaining the prorperty currency of the Entity in the context in one step and in a second step to do the override of this member. The requirement is to do it dinamically with the dinamic Link to the property.

I would really appreciate your help.

Regards,

Manuel

[former_member186338 · Accepted solution]

"Anyway i need to know if it is possible and how can be done, by EPM formula to establish this kind of filter:..." - This is not possible! And this is the correct answer.

[former_member186338 · Accepted solution]

P.S. It's not possible to use any EPM formula like EPMDimensionOverride to switch from specific member selection (like LC) to the member relation by property. If your report is for single entity (entity dimension in the page axis) then for sure you can get currency property from this cell and use it for currency override. For multiple entity members in row axis with specific currencies - there is no solution!

[manuel_medina1 · Accepted solution]

Thanks for your answer.

The requirement is for a complex report with different entities in rows where in each one it is required to show only its operative currency avoiding combination with other currencies ( That might me not the operative currency of the entity but the reporting currency).

[former_member186338 · Accepted solution]

manuel_medina

Sorry, but not clear:

"The requirement is for a complex report with different entities in rows where in each one it is required to show only its operative currency avoiding combination with other currencies ( That might me not the operative currency of the entity but the reporting currency)."

Better to provide some test case screenshot...