Standard Profitability AllocationType Dimensions

The AllocationType dimension is imported from the Profitability Applications Console.

This dimension is used to correctly allocate costs and revenue, and store direct allocations and allocation genealogy.

Note:

The AllocationType dimension can be renamed, if required.

In the Oracle Essbase outline created by Oracle Hyperion Profitability and Cost Management, the AllocationType dimension contains the following members:

• AllAllocations contains the following child members:

  • DirectAllocation stores calculated data that has been directly allocated within the model, between a specified source intersection and destination intersection. Direct allocation must be defined as an assignment by the user.

  • GenealogyAllocation stores the allocation genealogy that is calculated on indirect links between various concerned intersections in the model. For example, if stages 1-3-5 are selected:

    • Stages 1-3 includes both direct and indirect allocations

    • Stages 3-5 includes only indirect allocations

    Genealogy allocation is not directly defined by the user, but exists because of two or more direct allocations. For example, A-B-C allocation genealogy data exists because there is a direct allocation from A to B (A-B) and B to C (B-C).

• SysAllocVar1 stores the value for intrastage assignments on the virtual link, which is part of the value allocated to another node on the same stage, and is available in the DirectAllocation member.

• SysAllocVar2 is used to obtain a sum of the source links of DirectAllocation, Genealogy Allocation and SysAllocVar1.

• SysAllocVar3 stores calculated genealogy data that is used within the system. For example, if stages 1-3-5 are selected:

  • Stages 1-3 includes both direct and indirect allocations

  • Stages 3-5 includes only indirect allocations

  Caution:

  This member is for internal use only. Do not use this member in reports.

• TotalAllocation dynamically calculates the sum of the source links of DirectAllocation, GenealogyAllocation and SysAllocVar3.

• IndirectAllocation dynamically calculates the sum of the source links of GenealogyAllocation and SysAllocVar3.

The data in these dimensions cannot be modified, and it is not visible in Profitability and Cost Management.

Caution:

Do not edit the system members in this dimension, as any modifications may result in the loss of data or the corruption of the model.

The system automatically generates the AllocationType dimension if the user creates an application using the wizard, and checks "Auto Create Local Dimensions". If the user selects "Create Blank Application", the user must create their own dimensions and select the AllocationType dimension type.

When you create reports, the AllocationType dimension enables you to specify which type of allocation data to retrieve.