Transaction Type Dimension (Financial Consolidation)

Return to Financial Consolidation Overview

Elements in the Transaction Type dimension explain the transition from an opening balance in the beginning of a period through transactions to a closing balance at the end of a period. 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 calculated 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 these ways are available at the same time and can be mixed with each other. 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 Delta

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

T851 Delta from Closing (entry)

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

T855 Delta 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 submitt a closing balance in addition to opening and movements. This does not affect any of the other elements but can be used for lausibility checks.

T998 Delta from Closing (entry)

Stored end-of-period values. (numeric)

T999 Closing

Calculated closing balance at the end of each period. (calculated, 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 curing 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.