Cash Flow Model Overview

image_pdfimage_print

Return to Models Overview

Scope

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

Tasks

Database

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)

Interfaces

Import Exchange Rates Interfaces

Reports

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

Setup

Getting Started with the Cash Flow Model

Setting Up the Cash Flow Model

Configuration

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

Scaling

Other

Configuring Design Elements

Version Dimension

Month Dimension

Day Dimension

Legal Entity Dimension

   

 

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...