Cash Flow Cube (Financial Consolidation)


Return to Financial Consolidation Model Overview

The Cash Flow cube shows financial amounts for the cash flow statement. Most values are computed from the Profit and Loss and Balance Sheet cubes. Additional adjustments can be entered directly into the Cash Flow 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.
  • CF 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 CF Accounts Total of all accounts. Aggregated figures are usually meaningless at this level.

    See also CF 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.
  • Cash Flow_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)