Exchange Rates Report (Financial Consolidation)

Return to Financial Consolidation Overview

These reports offer inspection and maintenance of monthly exchange rates. The reports display values stored in the Exchange Rates_YTD cube. For information on importing exchange rates from an external source, see Import Exchange Rates Report.

Field

Description

Implementation

Version

Select Version element

Version dimension

Year

Select Year

Elements matching the pattern yyyy or FYyyyy of Month_YTD dimension

Conversion Type

Select one conversion type; alternately you can select All Conversion Types to show all conversion types at once.

Conversion Type dimension (with the exception of the Unassigned, Historic, and ~ elements).

Target Currency

Select target currency.

Base-level elements on level 2 under All Target Currencies of the Target Currency dimension. These elements consist of three uppercase letters, with the exception of XXX.

Import Exchange Rates

Hyperlink to report to run import interfaces

Opens Administration Reports/Import Exchange Rates.wss

Jan (YTD) … Dec (YTD)

Year-to-Data month in the selected year

Base-level descendants of selection Year in Month_YTD dimension.

Row label

ISO code of the currency. The localized name is shown as a tooltip when hovering the mouse cursor over the information symbol.

Next to this, the localized name of one or all selected conversion types is shown.

Currency dimension, descendants of All Currencies on level 1 or 2 consisting of three uppercase letters (excluding XXX).

Attribute Name.
If Conversion Type is set to All Conversion Types, then all children of this element (except for ~) are shown. Otherwise only the selected conversion type is shown.

Micro chart

Shows annual development. Useful to detect extreme deviations (e.g. because of a misplaced decimal separator or missing values)

Measure Exchange Rate from Exchange Rates_YTD cube.

Value

Exchange rate as equivalent of one unit of the target currency.

Measure Exchange Rate from Exchange Rates_YTDcube.