Show TOC

# Currency and Unit Display in Business Explorer

Use

There are various settings for displaying currencies in the Business Explorer.

Features

Displaying currencies and units in the results area of a query

Values in different currencies can be fundamentally aggregated and, by calculation, attached to the results area of the query. Linked values from different currencies are, however, displayed differently to values that have a common currency. There are, then, two different cases for displaying values and currencies when analyzing data in the Business Explorer.

• If all the values that go into the cell of the query's results area have the same currency, the associated value is displayed in this currency.

• In certain situations, it is impossible to clearly specify number values and texts for currencies or units. In these cases, predefined texts are displayed instead of number values and currencies or units.

• If the calculation contains a division by zero, "0/0" is displayed.

• If a number value cannot be found, NOP is displayed (does not exist).

• If a number value cannot be calculated due to a numeric overflow or another undefined mathematical function, "X" is displayed.

• If the values that go into a cell have different currencies, the value is displayed in a numerical, aggregated form. The currency will be represented by a placeholder. The symbol "*" is displayed instead of a currency identifier.

Example

The following rules are valid for aggregation behavior in the OLAP processor -example:

3 USD + 5 EUR = 8 *

3 USD + 0 EUR = 3 USD

0 USD + 0 EUR = 0 USD or 0 EUR, depending on the sequence

3 USD - 3 USD + 5 EUR = 5 EUR

3 USD + 5 EUR - 3 USD = 5 *

3 USD + 5 = 8 *, since it is an initial currency = currency ERROR

• To drilldown further by currency, you must define the characteristic Currency/Unit as a free characteristic in the query definition. The amounts you specified for the different currencies can now be entered into the query cells by drilling down on Currency/Unit (1 CUDIM).

• As an alternative, you can also display the various currencies in the query monitor (  SAP Easy Access  Business Explorer  BEx Monitor  Query Monitor ). Execute the query and choose Key Figure Definition from the results list. Currencies and units are always broken down for display -never aggregated.

Example

Country

Actual Revenue

Currency

Plan Revenue

Currency

USA

734

USD

700

USD

Germany

82

EUR

50

USD

Switzerland

70

*

50

USD

Result

886

*

800

USD

 Country Currency/Unit Actual Revenue Currency Plan Revenue Currency USA USD US Dollar 734 USD 700 USD Germany EUR Euro 82 EUR 50 USD Switzerland EUR Euro 40 EUR CHF Swiss Francs 30 CHF USD US Dollar 50 USD Result 886 * 800 USD
• If a user is not authorized to display a certain number value of a cell in the active query, you can display a text in the cell instead.

• If a calculated number value is made up of different currencies or units, you can choose to either display the number value or not. Choose mixed values to display the number value. If the 'mixed value'setting is not active, the text that you entered under 'mixed currencies'is displayed.

You can change these predefined texts in Customizing. To do so, choose  SAP Customizing Implementation Guide  SAP NetWeaver  SAP Business Information Warehouse  Reporting-Relevant Settings  General Reporting Settings in the Business Explorer  Displaying Number Values in the Business Explorer .

Displaying the Currency Key

The currency key can be displayed only in the column heading under the following conditions -instead of before or after the currency value:

• The currency for a query was translated into a common target currency.

• The data source only provides one currency so that a translation into a common target currency is not necessary.

To display the currency key in the column header, select Properties for the appropriate column using the context menu. Under Display, select Scaling Factors for Displaying Key Figures and choose OK. The currency key is taken from the column fields and displayed in the column header.

Also note the Priority Rule for Formatting Settings for this kind of formatting settings.

Setting up the currency display

In Customizing, you can make settings for how you want to display the currencies. You can decide which key you want each currency to be displayed with, and whether the key is placed before or after the value.

Example

Currency (ISO norm)

Alt. Text

Before or After Value

EUR

EUR

After value

USD

\$

Before value

GBP

£

Before value

Note

The above values are displayed for each default setting, just as the example shows. If you want to change these settings, you can do so in Customizing.

To make the settings in Customizing, go to the SAP Customizing Implementation Guide and choose  SAP NetWeaver  SAP Business Information Warehouse  Reporting-Relevant Settings  General Reporting Settings in Business Explorer  Set Alternative Display for Currencies .