Tracing Allocation Detail

  To trace allocation detail:

1. Ensure all allocation scripts have been run.

   See Calculating Direct Allocation Data.

2. From Task Areas, select Manage Allocations, then Trace Allocations.

   The Traceability screen is displayed.

3. Select a POV, and then click the Go button .

4. Select a Layer.

5. Under Starting Point, select Prefs to choose your preferences for the information to be traced:

   • Select the type of database to use for tracing allocations:

     • Calculation Essbase Database

     • Reporting Essbase Database

   • Select the type of trace to be performed:

     • Allocation Detail to follow allocations, step-by-step, directly from a source intersection to its ultimate destination

     • Allocation Flow to display the source and destination intersections that have an indirect relationship, rather than a direct assignment, to the selected intersection.

   • Select a display mode for the map:

     • Display Alias

     • Display Name

       Note:

       If Display Alias is selected, and no alias is set, the Display Name is shown in square brackets ([ ]).

6. For each dimension, click the selector button , and select the member to specify the intersection from which you want to begin tracing.

   Note:

   You must select the lowest level member in order to display the allocation.

7. Select Allocation Detail.

8. Click the Trace button to begin mapping the financial flow.

   The selected intersection is displayed on the screen, showing the name of the stage, and the members selected for each dimension in the intersection. The Properties for the starting point of the selected intersection are displayed at the bottom of the screen.

   

   Note:

   You can drag the entire flow diagram to position it for a more effective view. Depending on the number of dimensions in your model stage, you may need to stretch or scroll the window to see the Trace button on the far right side of the task bar.

9. Optional: On the intersection header, select the Trace Allocation Context Menu , and then select the maximum number of nodes that you want to display when the selected intersection is expanded (3, 5, 10 or 20). You can repeat this selection on any intersection.

10. Click the intersection to highlight the source node.

    Note:

    The expand node is only displayed on the intersection after it has been selected.

11. Under Properties, review the Source Detail that pertains to the selected intersection.

    The following information is provided about the source:

    • Source lists all dimension members selected for the starting point.

    • Net Cost For Assignment

    • Idle Cost, if any.

    • Cost Assigned

    • Total Driver Value

    • OverDriven, if any

    • StandardCostRate, if any

12. Select the next intersection to view, and click the expand icon to view the incoming or outgoing allocations for the selected intersection. You can navigate either upstream or downstream by expanding the nodes on either side of the intersection.

    The intersections that contribute to, or receive value from, the starting point show the stage and associated members. The percentage for each allocation is displayed, from highest to lowest.

    The percentages displayed for a stage will not equal 100% if the following conditions exist:

    • If there are idle costs on an intersection.

    • If there is cost input at a destination when drilling upstream (back to the source).

    

13. Double-click the stage header to expand and view the intersections that are included in the allocation. The source and destination intersections are highlighted.

14. Click any intersection to view its details in the Properties pane at the bottom of the screen.

    The following details are displayed:

    • Under Source Detail:

      • Source displays the dimension members included in the intersection from which the value has been contributed

      • Net Cost For Assignment

      • Idle Cost, if any

      • Cost Assigned

      • Total Driver Value

      • OverDriven, if any

      • Standard Rate, if any

    • Under Allocation Detail:

      • Amount of the allocation

      • Driver Name

      • Driver Value

    • Under Destination Detail:

      • Destination displays the dimension members included in the intersection to which the value is allocated

      • Cost Received

      • Cost Input

      • Net Cost For Assignment

      Note:

      For an explanation of the measures listed under Properties, see Measures Dimension.

15. Follow the flow throughout the model, as required:

    • Use the expand icon to follow the direct allocations throughout the model

    • Use the collapse icon to close the list of intersections.