To define currency translation

Context

You can translate the currency for all measures of an analysis.

Select a crosstab cell.
Choose Measures Currency Translation .
In the Currency Conversion dialog, select a Target Currency, a Currency Conversion Type and press OK.
The currency conversion types are created in SAP NetWeaver BW. For more information, see SAP Help Portal at http://help.sap.com.

Note The selection options in the Target Currency and Currency Conversion Type lists are interdependent. Depending on the currency you selected, the system offers you all conversion types that support this currency. To be able to display all conversion types again, choose the standard setting Display Original Currency. Conversely, if you select a particular conversion type, the system shows all currency options for this conversion type.
Select the Use Currency Translation from Query Definition check box, if the currency translation should be based on the currency definition in the BEx Query Designer.
The currency that you define in the query definition can be different from the currency in the original InfoProvider. For example, in the InfoProvider the currency USD is used and in the query definition, the currency is translated from USD to EUR. If you want to translate the currency in your analysis to GBP, the currency translation is based on EUR if you select this check box and it is based on USD, if you do not select it.

Note The check box is only available in the dialog when you select the Advanced Options in the User Settings.

All measures that are scaled in a currency are translated to the selected currency.