Cash Flow Model Overview


Return to Models Overview


The Cash Flow model contains financial data that is needed to produce financial statements for cash flow. This model extends the functionality of the Profit and Loss and the Balance Sheet models. The financial data utilizes a customizable chart of accounts. Facts that are stored in the Profit and Loss and Balance Sheet cubes are calculated and shown in the Cash Flow cube.

This model requires the Profit and Loss and Balance Sheet models to be installed on the same database.

Technical Documentation



Cash Flow Cube

Cash Flow Mapping Cube

Cash Flow Calculation Cube

Daily Exchange Rates Cube

Exchange Rates Cube

Fact Cube Using Currency Conversion

Business Logic

Version Blending

KPI Calculations for Cash Flow Cube

Previous Year

Currency Conversion (Cash Flow Model) 

Integration of Detail-Planning Cubes (Cash Flow Cube)

Semi-Additive Measures (Cash Flow Model)


Import Exchange Rates Interfaces


Cash Flow Actual Report

Cash Flow Forecast Report

Cash Flow Budget Report

Administration Reports

Legal Entity Administration Report

Exchange Rates Report

Import Exchange Rates Report


Getting Started with the Cash Flow Model

Setting Up the Cash Flow Model


Cash Flow Cube

CF Account 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)