Currency and Unit Display in Business
Explorer
Use
There are various settings for displaying currencies in Business Explorer.
Features
Displaying currencies and units in the results area of a query
Values in different currencies can be fundamentally aggregated and attached by calculation to the query’s results area. Linked values from different currencies are displayed differently to values that have a common currency however. This means that there are two different cases for displaying values and currencies when analyzing data in Business Explorer.
● If all the values that go into the cell of the results area for the query have the same currency, the value belonging to it 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 there is a division by zero in the calculation of a number value, “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 mathematic
function (for example
), the output
becomes „X“.
· If the values that go into a cell have different currencies, then the value is displayed in a numerical, aggregated form – there will be a placeholder for the currency. The symbol “*” is displayed instead of a currency identifier.
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.
Results area with different currencies
Country |
Actual Revenue |
Currency Key |
Plan Revenue |
Currency Key |
USA |
734 |
USD |
700 |
USD |
Germany |
82 |
EUR |
50 |
USD |
Switzerland |
70 |
* |
50 |
USD |
Result |
886 |
* |
800 |
USD |
Drilldown by currency/unit
Country |
Currency/Unit |
Actual Revenue |
Currency Key |
Plan Revenue |
Currency Key |
|
USA |
USD |
US Dollar |
734 |
USD |
700 |
USD |
Germany |
EUR |
Euro |
82 |
EUR |
50 |
USD |
Switzerland |
EUR |
Euro |
40 |
EUR |
|
|
|
CHF |
Swiss Franks |
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, the text can be displayed in the cell instead.
· If a calculated number value is made up of different currencies or units, the use can choose whether or not to display the number value. Choose mixed values to display the number value. If the ‘mixed values’ setting is not active, the text that you entered under ‘mixed currencies’ is displayed.
You can change these predefined texts in Customizing. To do this, choose SAP Customizing Implementation Guide → SAP NetWeaver → SAP Business Information Warehouse → Reporting-Relevant Settings → General Reporting Settings in Business Explorer → Display of Numerical Values in 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 on the column in question 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 comes before or after the value.
Currency (ISO norm) |
Alt. Text |
Before or After Value |
EUR |
EUR |
After value |
USD |
$ |
Before value |
GBP |
£ |
Before value |
The values above are displayed for each default setting as shown in the example. You can change these settings in Customizing if required.
To make the settings in Customizing, from the SAP Customizing Implementation Guide, choose SAP NetWeaver → SAP Business Information Warehouse → Reporting-relevant Settings → Set Alternative Display for Currencies.