Balance Sheet Cube

Balance Sheet Model Overview

Financial amounts for the balance sheet statement are maintained in the Balance Sheet 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
• BS 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 BS Accounts	Total of all accounts. Aggregated figures are usually meaningless at this level.

  
  See also BS Account Dimension
  
• Transaction Type: See article Transaction Type Dimension

• Balance Sheet_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)
  Data Validations	List of elements that contain the data validations for Balance sheet cube.
  Data Validation Errors	List of elements that contain the number of data validation errors for each data validation element for Balance sheet cube.
  Data Validation Warnings	List of elements that contain the number of data validation warnings for each data validation element for Balance sheet cube.

Updated February 7, 2024