Balance Sheet Model Overview


Return to Models Overview


The Balance Sheet model addresses financial data to provide financial statements for the balance sheet. The financial data is aligned to a customizable chart of accounts. Facts are stored in the main Balance Sheet cube. Amounts are stored in source currency and can be converted into one or multiple reporting currencies. Actuals may be imported from a financial accounting source system or entered manually.

Technical Documentation



Balance Sheet Cube

Daily Exchange Rates Cube

Exchange Rates Cube

Fact Cube Using Currency Conversion

Business Logic

Version Blending

KPI Calculations (by Version) for Balance Sheet Cube

Previous Year

Currency Conversion (Balance Sheet Model) 

Integration of Detail-Planning Cubes (Balance Sheet Cube)

Semi-Additive Measures (Balance Sheet Model)

Debit Credit Shift


Import Exchange Rates Interfaces


Balance Sheet Actual Report

Balance Sheet Forecast Report

Balance Sheet Mid-Term Planning Report

Balance Sheet Budget Report

Balance Sheet Legal Entity Breakdown Report

Administration Reports

Legal Entity Administration Report

Exchange Rates Report

Import Exchange Rates Report


Getting Started with the Balance Sheet Model

Setting Up the Balance Sheet Model


Balance Sheet Cube

BS Account Dimension

Transaction Type Dimension

Currency Conversion

Setting Up the Available Source Currencies

Setting up the Target Currencies

Configuration of Conversion Types

Setting Up Additional Conversion Types

Conversion from Implicit Local Currency

Conversion from Explicit Source Currency

Comparison of Currency Conversions

Synchronizing Exchange Rates in Forecast and Budget Versions

Exchange Rates



Configuring Design Elements

Version Dimension

Month Dimension

Day Dimension

Legal Entity Dimension


Was this post helpful?
NoYes (No Ratings Yet)