Reporting on Stage Data

You can generate reports to provide details about an individual model stage.

Example of Stage Data Report Selections

The example shows the layout of dimensions to generate a Stage Data report.

The sample report above shows the layout of dimensions used to create the stage data report:

  1. AllocationType set to DirectAllocation

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

  3. Stage dimensions

  To report on Stage Data:

  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. Drag and drop the dimensions into the configuration you require. For example, place source stage intersections in the rows, and destination stage intersections in the columns, or vice versa.

  4. Select members from each dimension in the source stage to define the source intersections on which you want to report.

  5. Select members from each dimension in the destination stage to define the destination intersections on which you want to report.

  6. From the AllocationType dimension, select DirectAllocation.

  7. Select a member from each POV dimension.

  8. From the Measures dimension, select the measures on which you want to report. See Measures Dimension.

  9. For all other dimensions, select NoMember.

  10. Using instructions for your reporting application, run the report.