Profit and Loss Model Overview


Return to Models Overview

Go to Jedox Online Courses for videos on The Profit and Loss Model


The Profit and Loss Model addresses financial data to provide the financial statements for profit and loss and profit appropriation. The financial data is aligned to a customizable chart of accounts. Facts are stored in the main cube, Profit and Loss. 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



Profit and Loss Cube

Daily Exchange Rates Cube

Exchange Rates Cube

Fact Cube Using Currency Conversion

Business Logic

Version Blending

KPI Calculations (by Version) for Profit and Loss Cube

Previous Year

Currency Conversion

Integration of Detail-Planning Cubes (Profit and Loss Cube)

Semi-Additive Measures


Import Exchange Rates Interfaces


Profit and Loss Actual Report

Profit and Loss Forecast Report

Profit and Loss Mid-Term Planning Report

Profit and Loss Budget Report

Profit and Loss Legal Entity Breakdown Report

Profit and Loss Time Series Report

Administration Reports

Legal Entity Administration Report

Exchange Rates Report

Forecast Initialization Report

Import Exchange Rates Report


Getting Started with the Profit and Loss Model

Setting Up the Profit and Loss Model


Profit and Loss Cube

PnL 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 (-1 rating, 1 votes)