specific currency conversion in query designer with stored exchange rate

[nicolas_boizar]

Hello,

I have a requirement where I need to apply a currency conversion for a specific company without to affect the others.

The exchange rate,which is stored in the cube, is taken from the sales document item.

let's take an example :

• Company A stays in EUR (no need of currency conversion)
• Company B stays in CNY (no need of currency conversion)
• Company C is in EUR and needs to be converted in USD using the exchange rate stored in the cube. But the users would like to have the possibility to switch in EUR when needed.

Is there a way to use the currency translation feature from the query designer for this purpose ?

Don't I have another choice to work with calculated KF and duplicate the KFs in order to have one in EUR and one in USD ?

I am open to all ideas and recommendations.

Thank you very much for your help !

[nicolas_boizar]

No one has an idea ? 😞