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

Allocation Genealogy Report displays the layout of dimensions used to create the report.

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

  1. AllocationType set to GenealogyAllocation

  2. All dimensions in other stages are set to NoMember.

  3. Start point intersections

  4. End point intersections

  To report on Allocation genealogy:

  1. Generate and calculate the Essbase cube for the model, as outlined in Calculating Models.

  2. From your 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. See Measures Dimension.

  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 your reporting application, run the report.