Return to Financial Consolidation model Overview
The exchange rates for monthly year-to-date periods are maintained in Exchange Rates_YTD cube, which consists of the following dimensions:
Version:See article Version DimensionMonth_YTD:See article Month_YTD Dimension (Financial Consolidation)Conversion Typecontains the following elements:-
Element Definition All Conversion Types
Total of all conversion types; aggregated figures are usually meaningless at this level.
Unassigned This element should be empty most of the time. It may refer to Exchange Rates_YTDthat are missing when data is imported from a source system. During the data load, the missing elements are created on the fly under the parent Unassigned. When the dimension is maintained at a later point, the new elements will be relocated to their correct parent.~ This conversion type always contains a rate of 1 and can be used to prevent unwanted currency conversion, e.g. for number of heads.
Average The arithmetic average over all available daily exchange rates. This type can be used for currency conversion of flow quantities, e.g. revenue or travel costs.
Month End
The most recent exchange rate available in the month. This type can be used for currency conversion of stock quantities, e.g. intangible assets or liabilities.
Month Start
The opening exchange rate, equal to the month-end exchange rate of the previous month. This type can be used for currency conversion of
Openingtransaction type, defining the opening balance.Historic This conversion type is a placeholder for currency conversion with historical conversion rates. The
Exchange Ratecubes will not store exchange rates for this conversion type.
Currency:See article Fact Cube Using Currency Conversion (Financial Consolidation)Target Currency: Target of the currency conversion. Elements are usually ISO 4217 codes. See article Setting Up Target Currencies (Financial Consolidation)Exchange Rates_measure: See article
Updated August 28, 2023