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,

Manuel I recommend you see the following note 2027990 - When enable "Linked to Property"

Cause

If user want to use the "Linked to Property" function for ID of dimension:A and property of dimension:B, user should make sure that all the IDs of dimension:A are maintained as property value in dimension:B. If this is not configured, dimension members will not display correctly in report. Instead, the members in context menu would display in report.

Resolution

1. Logon to BPC Web Admin.
2. Go to dimension:B.
3. Add all the member IDs of dimension:A as the corresponding property value in dimension:B.
4. Save and process dimension:B.

Best Regards!!

Juan Pablo

[former_member186338]

Sorry, but this answer is not related to the question...

[manuel_medina1]

Hi juanpa810 ,

Thanks for the note link.

I have reviewed and this explanation is usefull but I dont have any problem or doubt about how to link member selection to properties. I can do this link selection perfectly inside the report. What i do not know is if i can do it from Epm formula in any way.

Thanks