Profit and Loss Cube

Return to Profit and Loss 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: see article Version Dimension
• Month: see article Month Dimension
• Legal Entity: see article Legal Entity Dimension
• Currency: see article Fact Cube Using Currency Conversion
• 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

• Profit and Loss_measure: contains the following measures:
  
  

  Element	Definition
  Input	Main element to store facts from import procedures or manual input. (numeric)
  Adjustment	Element to manually enter adjustments to the amount posted in financial accounting. Used only for actuals. (numeric)
  Adjusted	Total of Input and Adjustment. (consolidated element)
  Comment	Additional explanation of the planned amounts stored in Input or on the performance of actual figures and their adjustments. (string)

Updated August 25, 2023