1. Administering and Working with Enterprise Profitability and Cost Management
  2. Building and Calculating Models
  3. Creating and Managing Rules
  4. Creating Allocation Rules
  5. Defining an Allocation Rule Driver

Defining an Allocation Rule Driver

The driver definition tells the system how to split the source data across the destinations.

Select an option to specify how to allocate the data:

  • Allocate Evenly: Allocates data evenly across all destinations.

  • Specify Driver Location: Uses a driver to determine the percentages to allocate to each destination. If a destination has no driver value, then it receives no allocation.

If you choose to use a driver to determine the allocation proportions, note the following:

  • All of the dimensions in the database are available to use as a driver, regardless of whether a Rule Set Context or a Model Context has been enabled for the rule. (See Understanding Model and Rule Set Context.)

  • In addition to the Entity and Account dimensions, optional Currency dimension, and any custom dimensions required to create a rule, the Years, Period, Scenario, and Version POV dimensions and the PCM_Balance and PCM_Rule system dimensions are available for driver selection.

    • The POV dimensions enable you to use a data value from another POV for the driver.

    • The PCM_Rule dimension enables you to use a data value generated by a previous rule for the driver.

    • The PCM_Balance dimension is usually used in combination with the PCM_Rule dimension. When a rule runs, it writes the result to the intersection of the rule member and the Allocation In or Allocation Out balance members.

All of the dimensions, with the exception of the system dimensions, are initially set to Same As Destination. PCM_Rule is set to NoRule, and PCM_Balance is set to Input. These are the default settings. Leave the dimensions at their default values if you want the driver value to be referenced by the destination locations defined on the Source/Destination tab.

If you want the driver value to be referenced by a fixed member that is different than the destination location, you can have only one driver member selection per dimension, and it must be a single member. It can be either an upper-level member or a level-0 member, but you can have only one selection per dimension.

To change the driver location reference to a fixed member:

  1. Click the default Same As Destination value next to a dimension, and then click Invoke Member Selector icon.

    If you are specifying a fixed member for the PCM_Balance dimension, click the default Input value and select Remove Input. The driver value changes to Same As Destination. Click Same As Destination, and then click Invoke Member Selector icon.

    If you are specifying a fixed member for the PCM_Rule dimension, click the default NoRule value,and select Remove NoRule. The driver value changes to Same As Destination. Click Same As Destination, and then click Invoke Member Selector icon.

  2. In the Select Members dialog box, select the dimension member that will be used to calculate the allocation. See Using the Member Selector.

    You can select only one member per dimension for the driver. The member selected can be an upper-level member or a level-0 member.

    You can optionally click Driver Dimension Member Editor icon to the right of the Specify Driver Location heading and enter the members to use as the driver in the Dimension Member Editor. The members will be added to the dimensions to which they were assigned when the dimensions were created. See Adding Members to a Dimension.