Currency conversion with variable in selection mask with problems

[Former Member]

Hi Gurus,

I want to implement a currency conversion as follows:

when the query is opened a selection screen should appear and the whole data which is with Euro currency should be possible to translate in USD, GBP, FRF (depends on which currency the user is choosing).

I did a conversion with a variable with default value USD but I am not able to insert multiple currencies like GBP and FRF as default value/ suggestion in variable.

I created a variable on 0Currency with following adjustments:

- Processing By: Manual Input/Default Value.

- Reference Characteristic (0CURRENCY) Currency.

- Variable Represents: Single Value.

- Ready for input: checked

- default value: USD.

With adjustment "variable represents" > "single value" it is not possible to insert two or three currencies as default value.

When changing "variable represents" to "multiple single values" or to "selection option" it is possible to insert two or three currencies as default value.

But when the variable is saved with "multiple single values" or "selection option" the variable doesn´t appear in currency translation type in tab currency when selecting target currency with option "target currency from variable".

Any idea why the variable doesn´t appear with adjustments with "multiple single values" or "selection option"?

Or any idea how it is possible to achieve my whished currency conversion?

Thanks in advance!

[former_member211907]

saplaz-

If I read your request properly, you would like to be able to translate values to any one currency at a time, from a possible list of currency. Remove the default value and whatever currencies are available in your RSCURR should be there.

It is NOT possible to translate a single currency key figure into more than one currency using a single currency translation. That is why the variable only allows a single entry. If you DO want to display multiple currencies, you'll need to have multiple key figures with different translations (and variables) associated with them. For example:

Key Figure A: Sales - Variable "A", Translation A

Key Figure B: Sales- Variable "B", Translation B

Key Figure C: Sales- Variable "C", Translation C

End user enters

Variable A= GBP

Variable B= USD

Variable C= MXP

Report shows:

Sales in Pounds, Sales in Dollars, Sales in Pesos

[Former Member]

saplaz-
> If I read your request properly, you would like to be able to translate values to any one currency at a time, from a possible list of currency. Remove the default value and whatever currencies are available in your RSCURR should be there.

That´s correct. I want to have a list of currencies in which it would be possible to translate. That means clicking in selection mask and the list appears.

That was my first thougth ... removing the default value. I removed the default value but only Euro (EUR) appeared in that list for selecting. I thought this has maybe something to do with the data which is available in the cube and that is only in EUR.

I will check the RSCURR and what kind of currencies are available.

cheers