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_member223971]

Hi Manuel,

You can try adding EPMMemberProperty inside the Override, as follows.

=EPMDimensionOverride("000";"RPTCURRENCY";EPMMemberProperty(;EPMContextMember(;"ENTITY");"CURRENCY"))

Or

=EPMDimensionOverride("000";"RPTCURRENCY";"ENTITY:"&EPMMemberProperty(;EPMContextMember(;"ENTITY");"CURRENCY"))

Regards,

Juan Pablo

[former_member186338]

Your first formula is more or less OK, but the second one is incorrect:

=EPMDimensionOverride("000";"RPTCURRENCY";"ENTITY:"&EPMMemberProperty(;EPMContextMember(;"ENTITY");"CURRENCY"))

Result will be like:

RPTCURRENCY ENTITY:USD - meaningless!