Transaction Type Dimension (Financial Consolidation)

image_pdfimage_print

Return to Financial Consolidation Overview

Elements in the Transaction Type dimension explain all transitions throughout a period, beginning with the opening balance and ending with the closing balance. The Balance Sheet cube features multiple ways to store data:

Storage of opening balance and changes

The opening balance in the beginning of the fiscal year is stored in the T000 (Opening) element. All movements are stored in several elements in the range T001T799. The T999 (Closing) element shows the aggregated closing balance at the end of each period.

If the changes are not available by individual movements but only as a netted change, this can be stored in T299 (Increase (decrease) through other changes).

Storage of end-of-period values

The opening and closing balances for each period are stored in the T000 (Opening) and T998 (Closing (entry)) elements. The T851 (Delta from Closing (entry)) element shows the calculated changes.

Example:

All movements are available simultaneously and can be mixed with one another. The dimension contains the following elements:

Element

Definition

T000 Opening

Stored opening balance in the beginning of the fiscal year. (numeric)

Range T001T099

 

Reserved for the Financial Consolidaton model to store consolidation results near the beginning of the fiscal year.

Range T100T799

Usable for custom configuration

T800 FXDiff

Foreign exchange differences on converted currencies. (calculated, numeric)

T820 Total increase

Subtotal of all movements increasing the balance from bookings of the general ledger. Should always be a positive amount. (aggregated, numeric)

T829 Total increase (decrease)

 

Subtotal of all movements which may either increase or decrease the balance from bookings of the general ledger. Can be a positive or a negative amount. (aggregated, numeric)

T830 Total decrease

Subtotal of all movements decreasing the balance from bookings of the general ledger. Should always be a negative amount. (aggregated, numeric)

T850 Movements

Total of all transactions from T855 Movements Transactions and T851 Movements from Closing (entry). (aggregated, numeric)

T851 Movements from Closing (entry)

Changes between the current and previous period calculated from the values on T998 (Movements from Closing (entry)). (calculated, numeric)

T855 Movements Transactions

Total of all transactions from T820 Total increase, T829 Total increase (decrease) and T830 Total decrease. (aggregated, numeric)

Range T901T996

Reserved for the Financial Consolidaton model to store consolidation results near the endng of the fiscal year.

T997 Closing (information purposes)

Storage to submit a closing balance in addition to opening and movements. This does not affect any of the other elements but can be used for plausibility checks.

T998 Movements from Closing (entry)

Stored end-of-period values. (numeric)

T999 Closing

Closing balance at the end of each period. (aggregated, numeric)

 

The transaction type elements can be configured through their attributes:

Attribute

Description

Name

Readable name of the account. Localized translations can be provided. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string)

ID_Name

 

Technical element name of the account as well as the readable name. If localized translations are provided Name attribute, this attribute will also become localized. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string, calculated)

Label

Short version of the name, e.g. column heading. Localized translations can be provided. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string)

Conversion Type

Defines which exchange rate is used during currency conversion. Valid values are base elements of the Conversion Type dimension, e.g. Average, Month End, Month Start, Historic and ~.

Aggregation Type

Semi-additive measure behavior. (string)

Valid values are:

  • (empty): Regular additive behavior
  • First: First child
  • Last: Last child
  • Avg: Average of children

See Fact Cube Using Currency Conversion and Configuration of Conversion Types.

Movement Schedules

Valid combinations between the Transaction Type dimension and the BS Account dimension are defined through movement schedules. Our sample data comes with five such movement schedules.

The five sample movement schedule are described below:

Hierarchy Name
SoCE.T999 Changes in equity
BCmb.T999 Business combinations
Prop.T999 Property, plant and equipment
IntA.T999 Intangible assets
InvP.T999 Investment property

Each movement schedule in the Transaction Type dimension is implemented as a parallel hierarchy. Each hierarchy is made from parent-child relations. The base elements in these hierarchies must be stored in the range T000T998. By sharing the these base elements, the movement schedules are reduced to valid transaction types that re-use the same data as the T999 (Closing) element.

The consolidated elements in these hierarchies represent the reporting lines revealed on the reports.The lowest consolidated element should have only one child, which remains hidden from the report. This allows schedule-specific naming of the lowest reporting lines (e.g. Goodwill at beginning of Period), while still sharing the data of the base elements (e.g. T000 (Opening)).

The Financial Consolidation model comes with an assortment of movement schedules. You may use these as is, modify them, or create new ones. Removing one of the above hierarchies will break its corresponding report.

image_pdfimage_print