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
: TheVersion
dimension separates actual figures from planning figures. See full article.Month_YTD
: TheMonth_YTD
dimension holds aggregated values from the beginning of the calendar or fiscal year to the end of a month. See full article.Scope
: TheScope
dimension contains all target elements for financial consolidation in a flat list. See full article.Legal Entity
: Elements in theLegal 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 thePartner Entity
dimension represent business relationships with other companies in a group. See full article.Currency
: See Fact Cube Using Currency Conversion (Financial Consolidation) 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 (Financial Consolidation).
Consolidation
: Elements in the Consolidation dimension represent levels in the financial consolidation process, starting with the collected separate financial statements on theLocal GAAP
element and ending with the final result on theConsolidated 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)
Updated August 28, 2023