Profit and Loss Cube (Financial Consolidation)


Return to Financial Consolidation Model Overview

Financial amounts for the profit and loss statement are maintained in the Profit and Loss cube, which consists of the following dimensions:

  • Version: The Version dimension separates actual figures from planning figures. See full article.
  • Month_YTD: The Month_YTD dimension holds aggregated values from the beginning of the calendar or fiscal year to the end of a month. See full article.
  • Scope: The Scope dimension contains all target elements for financial consolidation in a flat list. See full article.
  • Legal Entity: Elements in the Legal Entity dimension represent the companies within a group, i.e. those companies for which you need a separate financial statement. See full article.
  • Partner Entity: Elements in the Partner Entity dimension represent business relationships with other companies in a group. See full article.
  • Currency: See Fact Cube Using Currency Conversion article.
  • PnL Account:
Element Definition
Account hierarchy consisting of report items. The hierarchy breaks down into more granular reporting lines. Alternatively, the report items can be broken down into ledger accounts.
All PnL Accounts Total of all accounts. Aggregated figures are usually meaningless at this level.

See also PnL Account Dimension.

  • Consolidation: Elements in the Consolidation dimension represent levels in the financial consolidation process, starting with the collected separate financial statements on the Local GAAP element and ending with the final result on the Consolidated Adjusted element.
  • Profit and Loss_measure: Contains the following measures:

    Element Definition
    Value Main element to store facts from import procedures or manual input. (numeric)
    Comment Additional explanation of the planned amounts stored in Value or on the performance of actual figures and their adjustments. (string)