Skip to Content
author's profile photo Former Member
Former Member

Currency conversion with variable in selection mask with problems

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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 23, 2011 at 09:16 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.