Transaction Type Dimension

Return to Models 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 first period of the fiscal year is stored in the Opening element. All changes are stored in Increase or Decrease. The Closing element shows the calculated closing balance at the end of each period. For all consecutive periods, the Opening elements shows the calculated opening balance.

If the changes are not available by increase and decrease but only as a netted change, this can be stored in Delta Transactions~.

Storage of end-of-period values

The closing balance for each period is stored in the ~ element. The Delta ~ element shows the calculated changes and the Opening element shows the calculated opening balances in each period. Note that the opening balance in the beginning of the initial period is not defined through the available data and Opening remains zero in this period.

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
Opening	Stored opening balance in the beginning of the first period of the fiscal year. For all consecutive periods, the `Opening` element shows the calculated opening balance. (partly calculated, numeric)
Increase	Stored increasing changes from bookings of the general ledger. Should always be a positive amount. (numeric)
Decrease	Stored decreasing changes from bookings of the general ledger. Should always be a negative amount. (numeric)
Delta Transactions~	Stored netted changes from bookings of the general ledger. (numeric)
Delta Transactions	Total of the stored transaction values on `Increase`, `Decrease` and `Delta Transactions~`. (aggregated, numeric)
Delta ~	Changes between the current and previous period calculated from the values on `~`. (calculated, numeric)
Delta	Total of all transactions from `Delta Transactions` and `Delta ~`. (aggregated, numeric)
Delta w/o Decrease	Total of all Increase and all other changes except for `Decrease`. (aggregated, numeric)
~	Stored end-of-period values. (numeric)
FXDiff	Foreign exchange differences on converted currencies. See article Currency Conversion (Balance Sheet Model). (calculated, numeric)
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)
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`, and `~`. See article Currency Conversion (Balance Sheet Model). (string)
Aggregation Type	See article Semi-Additive Measures (Balance Sheet Model). (string)

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

Updated September 25, 2024