Currency Translation in the Business Explorer

Use

Prerequisites

You previously created one or more currency translation types.

Features

When you want to translate a currency from key figures in the query, you can determine the translation type from two places:

In the query definition for individual key figures or structure elements
In the executed query, using the context menu for all elements of key figure type: amount

Currency Translation According to Query Definition

A more complex currency translation is available in the query definition. You can determine how the individual elements (key figures of type: amount) of the query are to be converted. One currency translation type can be specified for each element. Note that this can lead to overlays of two different translation types in one cell. Then the translation type that you most recently set is always used. See also the example Multiple Currency Translation Types in One Query

Depending on the definition of the target currency determination in the currency conversion type, either a fixed target currency or a variable for the determination of the target currency can also be specified.

See also the section Currency Translation in Properties of the Selection/Formula/Cell.

If a variable is used, the system will request the variable when you execute the query. You can see the procedure in Setting Up Variable Currency Translation.

The values of a query can, on the one hand, exist in different currencies, depending on the respective elements and the selected translation. On the other hand, various modalities for translation need to be taken into consideration (for example, a translation of plan data is done with year-dependent exchange rates and a translation of actual data is performed with month-dependent exchange rates).

Currency Translation in the Executed Query

In the BEx Analyzer, by choosing Query Properties in the context menu for the key figure, you can convert the displayed currency in various ways.

Convert to Currency as Defined in Query Definition: Complex currency translations can be configured using the BEx Query Designer. If such a translation has been configured in your query, this option is available and you can use it in your query results.
Convert to Currency: Select this option to convert results to a specific currency. In the dropdown list, select the currency in which you want the results to be displayed.
- Use Currency Translation: After you have selected the currency for the results, select the required translation type to use when converting from this dropdown box.
- Consider Translation from Query Definition: Select this checkbox to convert to the currency defined in the query first, and then convert to the currency specified in these settings.
Show Original Currency: Select this option to disable currency conversions.