Create an Allocation Rule with an Allocation Component

This example demonstrates how to create an allocation rule with allocation components.

You are the General Accountant for InFusion America Inc. You are creating an allocation rule with allocation components.

A rule consists of calculations that are grouped into components. When you design allocation rules, you add variables to components. Variables assume the values that you define for them. Replacement variables provide a substitution value when you design or generate an allocation rule.

Creating an Allocation Rule with an Allocation Component

  1. Click the Navigator.

  2. Click the Journals link for the General Accounting work area to access the Journals work area.

  3. Click the Create Allocation Rules link.

  4. In the Enterprise Performance Management System Workspace, click the Navigate menu.

  5. Select Administer and then Calculation Manager.

  6. On the System View tab of Calculation Manager, expand the Essbase tree.

  7. Expand the VF_USA_Accounting_Flexfield tree node.

  8. Expand the db tree item.

  9. Right-click the Rules tree item.

  10. Select New.

  11. In the New Rule dialog box, enter EMEA Overhead Distribution in the Name field.

  12. Click OK.

    You design a rule by dragging components from the Rule Palette to the Rule Designer flow chart. Each component performs a separate task. You can add Point of View, Allocation, or Formula components to your rule.

    You enter additional rule details on the Properties tab.

  13. In the Rule Palette area, drag the Point of View object to the Rule Designer area.

    The begin and end components of the rule appear in the Rule Designer work area.

  14. On the Point of View tab, click in the Ledger field of the Dimension value table.

  15. Click the Actions button for the Ledger field.

  16. Select Member.

  17. In the Member Selector dialog box, expand the Ledger tree, and expand the All Ledgers tree node.

  18. Click the Vision Operations (USA) tree item and click Select to move it to the Selections panel.

  19. Click OK.

  20. Repeat the preceding steps and complete the following dimension fields, as shown in this table.

    Field

    Value

    Company

    "All Company Values","00"

    Sub-Account

    "All Sub-Account Values","0000"

    Product

    "All Product Values","[Product]@[000]"

    Currency

    "USD"

  21. From the Rule Palette, drag Allocation to the Rule Designer panel.

  22. In the Allocate Wizard, click in the Value column of the AccountingPeriod field.

  23. Click the Actions button.

  24. Select Variable.

  25. In the Select Variable dialog box, select Database in the Category field.

  26. Click the Balancing_Segment_Value field, and click OK.

  27. Click Next.

  28. Click in the Select Value column of the Company field.

  29. Click the Actions button.

  30. Select Member.

  31. In the Member Selector dialog box, expand the Company tree.

  32. Expand the All Company Values tree item.

  33. Click the 00 tree item.

  34. Click Select to move it to the Selections panel.

  35. Click Next.

  36. Use the preceding procedure and complete the dimension fields, as shown in this table.

    Field

    Value

    Action

    Department

    "[Department]@[000]"

    Member

    Account

    an account

    Member

  37. Click Save and then OK.