Show TOC

Currency Translation in Business ExplorerLocate this document in the navigation structure

Use
Prerequisites

You have created one or more currency translation types.

More information: Creating Currency Translation Types.

Features

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

  1. In the query definition for individual key figures or structure elements

  2. 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 cause overlapping of two different translation types in one cell. If this occurs, the system always uses the translation type you set most recently. See 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 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 exist in different currencies, depending on the corresponding elements and the currency translation selected. At the same time, you need to take account of certain currency translation modalities (translation of plan data is performed with year-specific exchange rates for example, whereas actual data is translated using month-specific exchange rates).

Currency Translation in the Executed Query

By choosing Query Properties in the context menu for the key figure in BEx Analyzer, you have various options for translating the displayed currency.

  • Translate to Currency as Defined in Query: Complex currency translations can be configured using BEx Query Designer. If this type of translation is configured in your query, you can use this function in your query results.

  • Translate to Currency: Select this option to translate results to a specific currency. In the dropdown list, select the currency that you want the results to be displayed in.

    • 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.

  • Display Original Currency: Select this option to disable currency translations.

See also Query Properties.

In BEx Web Applications, a simple currency translation is available with the context menu. In input help for the target currency however, only the currencies that exchange rates are maintained for in the system are displayed, whereas all currencies are displayed in BEx Analyzer.

More information: Start of the navigation path http://help.sap.com/nw73 Next navigation step Application Help Next navigation step SAP Library Next navigation step SAP NetWeaver Next navigation step SAP NetWeaver Library: Function-Oriented View Next navigation step Business Warehouse Next navigation step SAP Business Explorer Next navigation step BEx Web Next navigation step Analysis & Reporting: BEx Web Applications Next navigation step Context Menu Functions Next navigation step Perform Currency Translation End of the navigation path

Restrictions:

The following currency translation types are not available at the runtime of the query.

  • Inactive translation types

  • Translation types for which a variable is stored (variable time reference, source currency from variable, target currency from variable, and so on)

  • Translation types in which an InfoObject is used for determining the source currency or target currency or time reference.

Currency Translation Is Possible…

  • Generally only for the use of selection elements (formulas are applied to translated values).

  • When using formula variables with the dimensions Amount and Price

  • When using formula variables with a replacement path

  • With key figure attributes if the key figure is of type Amount