Generating the Level 0 Contribution Report

To generate a Level 0 Contribution Report:

1. Log in to Oracle Business Intelligence Enterprise Edition, and navigate to the Profitability and Cost Management repository.
2. In the Physical Layer, right-click a dimension view that you want to use in the report, then select New Object, and then Alias.

   For example, click HPMD_BKSDP20_CUSTOMERS_HIER_V in the Sample Model as the model for the Alias table.

3. Enter a name for the new Source Alias table (such as HPMD_BKSDP20_SRCCUST_HIER_V), and then click OK.
4. In the Physical Layer, right-click the dimension view again, then select New Object, and then Alias.
5. Enter a name for the new Destination Alias table (such as HPMD_BKSDP20_DESTCUST_HIER_V), and then click OK.
6. In the Physical Layer, select the following objects, then right-click and select Physical Diagram – Selected Objects Only:

   HPMD_BKSDP20_SRCCUST_HIER_V

   HPMD_BKSDP20_DESTCUST_HIER_V

   HPMD_BKSDP20_LEVEL_0_CONTRIB_V

7. In the diagram, make physical joins between each of the new Alias tables and the Level 0 Contribution view.
8. Drag the Source and Destination Alias tables to the Business Model Layer.
9. In the Presentation Layer, modify the Level 0 Report to include columns from each of the new Alias tables.

For additional information on working with Physical Tables and Aliases, see the Oracle Fusion Middleware Metadata Repository Builder’s Guide for Oracle Business Intelligence Enterprise Edition 11g Release (11.1.1), Chapter 7: Working with Physical Tables, Cubes and Joins.