Exchange Rates Report

Return to

Models Overview

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

Report Heading

The screenshot below points out the heading area of the Financial Consolidation Posting Journal. The logo can be changed in Administration; see Configuring Design Elements for more on report design.

 

 

 

Field

Description

Implementation

Version

Version dimension

Year

Elements matching the pattern yyyy or FYyyyy of Month dimension

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.

Conversion Type

Selection of one conversion type, or All Conversion Types to show all conversion types at once.

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

Import Exchange Rates

Hyperlink to report to run import interfaces

Opens Administration Reports/Import Exchange Rates.wss

Jan … Dec

Month in the selected year

Base-level descendants of selection Year in Month 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

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

Measure Exchange Rate from Exchange Rates cube.

Value

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

Measure Exchange Rate from Exchange Rates cube.

Updated July 8, 2024