Skip to Content

Currency Translation with Variable for Currency

I just read in my BW academy notes:

"All query values can be translated into one common target currency with an exchange rate type. You can make this setting when you define the query or create a currency variable beforehand. A default menu appears when you start the evaluation, where you can select the target currency you require."

Problem is I can't remember how to do it!

I would like to include a variable in my query so that the user can enter the currency in which the key figures will be displayed.

I know how to create a currency conversion type to allow the users to convert the currency from the context menu, and i know how to create a variable, but I cannot remember how to use the variable to set the reporting currency.

Can somebody help please.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2005 at 03:13 AM

    hi Stuart,

    check here ....

    and 'how to' doc

    Setting Variable Target Currency in the Query Designer


    You have created a currency translation type. You have selected the Selection of Target Currency with Translation option on the Target Currency tab page in this translation type.



    1. You are in the Query Designer. Choose Properties from the context menu of your amount key figure.

    2. Select your translation type under Currency Translation.

    3. Select the Variables Entry field and choose New Variable. The variables wizard appears. Also see, Defining Variables with the Variables Wizard .

    4. Enter a Variable Name and a Description for the variable.

    5. In the Processing by field, choose the processing type User Entry/Default Value. The Currency characteristic (0CURRENCY) is the default.

    6. Choose Continue to reach the Details screen. Here you decide how the entry is to appear. The following can be selected:

    ¡ optional

    ¡ mandatory

    ¡ mandatory, initial values not permitted

    This field is ready for input by default.

    7. Choose Continue to assign a default value for the variable.

    8. Choose Continue to get a summary of the properties of the variables. Choose Exit to save the variable and be able to use it in the query.


    When the query is executed, the system gets the variables for the target currency.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2005 at 06:14 PM

    Hi Stuart!

    Let me know your mail address...



    Add a comment
    10|10000 characters needed characters exceeded

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.