Integration of Detail-Planning Cubes (Balance Sheet Cube)


Return to Models Overview

When running the Profit and Loss and Balance Sheet models on the same OLAP database, detailed data from the Profit and Loss cube can be automatically integrated into the Balance Sheet cube. The integration is implemented as rules in the Balance Sheet cube. These rules are defined as part of the KPI calculation.

The sample data package for the model contains some samples for the integration. 


The BS Account element 211200 (Retained Earnings) integrates values from the PnL Account element 305000 (Profit (loss)) in the Profit and Loss cube.

  • The Transaction Type dimension exists only in the Balance Sheet cube. The value is integrated only into the Delta Transactions~ (Delta Transactions (entry)) element, while other elements are set to null. However, these other transaction-type elements are partly calculated, which takes precedence over the KPI calculation. See article Transaction Type Dimension.
  • All other dimensions are shared.

The rule expression for this is:

The integration is only valid for the actual version (assigned to the A calculation schema). The integration rule instances should be generated only if the source cube Profit and Loss exists.

The attributes for the BS Account element 211200 (Retained Earnings) are:






No integration for planning versions.




B:If( !’Transaction Type’ == …

The complete expression is shown above.


Cube:Profit and Loss

Create rule instance only if the source cube Profit and Loss exists.