Reporting on Allocation Genealogy

The Allocation Genealogy report calculates the allocation detail for source and destination intersections that do not have an assignment, but which have an indirect relationship.

Example of Allocation Genealogy Report Selections

The sample report above shows the layout of dimensions used to create the allocation genealogy report:

1. AllocationType set to IndirectAllocation

2. All dimensions in other stages set to NoMember

3. Start point intersections

4. End point intersections

To report on Allocation genealogy:

1. Generate and calculate the Oracle Essbase cube for the model, as outlined in Calculating Standard Profitability Models.
2. From the reporting application, connect to the Essbase cube.
3. In the Source Stage, select members from each dimension in the stage that is the starting point.
4. In the Destination Stage, select members from each dimension in the stage that is the ending point.

   Note:

   If there is an intrastage allocation, use the dimensions with the suffix _intra to specify the destination intersections.

5. From the AllocationType dimension, select GenealogyAllocation.
6. From the Measures dimension, select the measures on which you want to report.
7. Select a member from each POV dimension.
8. For all other dimensions, including dimensions for intermediate stages between the start and end point stages, select NoMember.
9. Using instructions for the reporting application, run the report.