Detailed Profitability Level 0 Contribution Report

A typical Detailed Profitability application may have one or more overlapping dimensions between the source and destination stages.

For example, in the BksDP30 sample model, note that the Customer and the Product dimensions are used in both the Source stage and in the Destination stage.

This results in a Level 0 Contribution view (for example, HPMD_BKSDP20_LEVEL_0_CONTRIB_V for the sample model) which has two columns for each of these overlapping dimensions – one for the source context and one for the destination context.

In order to use this view to successfully generate a contribution report in Oracle BI EE, you must know how to properly register the system-generated dimension reporting views within the Physical Layer in OBIEE, so that each can join properly to both sets of dimension columns in the Level 0 Contribution view. Within the physical layer, you must create two alias tables from the Level 0 view to the same dimension. For example, Level 0 view must join to the Customer dimension once for the Source (SRC) and once for the Destination (DEST).

The following instructions use the hierarchy dimension view from the Customer dimension in the sample model as an example of how to do this.