Business Transaction Mapping Cube

Return to Financial Consolidation Model Overview.

Business Transaction Mapping Cube contains sorted investment data. The related load process can be started from the button “Update Business Transaction Mapping” on the "Investment Register" Report.

Business Transaction Mapping Cube has the following dimensions:

• Version: See article Version Dimension

• Month_YTD: See article Month_YTD Dimension (Financial Consolidation)

• Legal Entity: See article Legal Entity Dimension (Financial Consolidation)

• Partner Entity: See article Partner Entity Dimension (Financial Consolidation)

• Business Transaction Type: is a list of possible transaction types. See article Business Transaction Type Dimension

• Business Transaction Event: is a flat list of numbers. It is a system-generated dimension and grows with the Investment Register. If there are more events for the same business combination during the same period, those are saved under different event numbers.

• Business Transaction Mapping_measure: shows the investment details and has four elements:

  Element	Definition
  Business Transaction	Business Transaction ID (String). This element is not rule-calculated and is updated when the Update Business Transaction Mapping job is executed on the Investment Register report.
  BS Account	Displays the account number of the balance sheet account (String). This element is not rule-calculated and is updated when the Update Business Transaction Mapping job is executed on the Investment Register report.
  PnL Account	Displays the account number of the profit and loss account (String). This element is not rule-calculated and is updated when the Update Business Transaction Mapping job is executed on the Investment Register report.
  Retained Earnings Account	Used Retained Earnings Account (String). This element is not rule-calculated and is updated when the Update Business Transaction Mapping job is executed on the Investment Register report.

Updated August 1, 2024