Integration of Detail-Planning Cubes (Balance Sheet Cube)

Return to Jedox 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.

Example

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:

B:If( !'Transaction Type' == "Delta Transactions~", PALO.DATA("", "Profit and Loss", !'Version', !'Month', !'Legal Entity', !'Currency', "305000", !'Balance Sheet_measure'), null )

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:

Attribute

Value

Remarks

PCalculation

No integration for planning versions.

PCalculationDependencies

ACalculation

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

The complete expression is shown above.

ACalculationDependencies

Cube:Profit and Loss

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

Updated September 25, 2024