Create an Allocation Component

Navigator > General Accounting: Journals > Create Allocation Rules link.

Navigate menu > Administration > Calculation Manager.

In the System View, select File menu, New, Rule. Expand the Essbase Application Type, the Application, and the Calculation Type, Plan Type, or Database.

Right-click the rule you want to open, and select Open. The rule is displayed in the Rule Designer.

After you determine where in the rule's flow chart you want to create the allocation component, from the New Objects Palette, drag the Allocation component and drop it into that location in the flow chart.

In the Calculation Manager, on the Point of View tab, for each dimension listed that you don't want to vary during the allocation, do one of these tasks, and then click Next.

Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.
Click the Member Selector icon to select members and variables for each of the dimensions listed. Make sure that all members you select are valid level 0 members.
Select a dimension in the list, and click Actions to select a member or variable.

Note: If you drop a Point of View component within another Point of View component, the second Point of View inherits the members, variables, and functions from the first Point of View. In the Member Selector, the dimensions listed in the current step are available for selection from Dimension. This enables you to select members and functions for any of the dimensions listed in the current step.

In the Calculation Manager, on the Source for each dimension listed, select a member whose data you want to allocate by doing one of these tasks. You must select a member for each dimension listed. The source members can be members that aren't level 0.

Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values. If the predefined selection doesn't enter a value for each dimension listed, you must enter a value for any dimensions that are empty.
Click the Member Selector icon to select a member for each of the dimensions listed.
Select a dimension in the list, and click Actions to select a member or variable. You can't use functions in this step of the Allocation component.
Optional, to allocate a specific value, enter an amount to be allocated instead of the selecting members.

If the source amount you want to allocate is zero, select one of these options from the drop-down list.

Select the next pool record.
Stop processing the allocation.

Click Next.

On Allocation Range, enter the parent member for the dimensions you want to use for the allocation. To enter the parent member, do one of these tasks, and then click Next.

Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.
Click the Member Selector icon to select the parent member for the dimension to which to allocate the data.
Enter a parent member, or select a dimension in the list. Click the Actions icon to select the parent member (of the main dimension) to which to allocate the data. The data is allocated to the level 0 member (the lowest member in the outline).

On Target, for the remaining dimensions, select a level 0 member to which to allocate the data. Perform one of these tasks and click Next.

Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.
Click the Member Selector icon to select members for each of the dimensions listed.
Select a dimension in the list, and click the Actions icon to select a member or variable.

On Offset, perform one of these tasks and click Next:

Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.
Click the Member Selector icon to select members for each of the dimensions listed.
Select a dimension in the list, and click the Actions icon to select a member or variable.

Note: You must specify members for the offset; you can't leave it empty.

Optional: On Exclude, select any members you want to exclude from the allocation. Perform one of these tasks and click Next.

Note: Use the Exclude tab for partial allocations. Specifically where you want to allocate a percentage of the total source and the percentage itself can't be entered. Instead, the percentage has to be calculated based on all the members in the basis and then some members have to be excluded from the allocation target range.For example, a basis contains cost centers 100, 200, 300, and 400. You want to distribute the source evenly across each cost center, so each cost center should be allocated 25% of the source. But you have to exclude cost center 300 from the allocation range. In this example, you would specify cost center 300 in the Exclude tab. When the allocations are generated, 75% of the source is allocated, 25% each to cost centers 100, 200, and 400. The 25% for cost center 300 remains unallocated because cost center 300 is excluded.

Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.
Click the Member Selector icon to select members for each of the dimensions listed.
Select a dimension in the list, and click the Actions icon to select a member or variable.

On Basis perform these tasks:

Select an allocation method to specify how the data should be allocated.
1. Select Allocate evenly to allocate data values in the allocation range evenly. Then on Basis Options for evenly method, specify what you want to be done if the basis is negative, zero, has missing values, or if all members are excluded.
2. Select Allocate using a basis to calculate a percentage to be applied to each member in the allocation range. Then on Basis Options, specify what you want to be done if the basis is negative or equal to zero.
Any dimension members you don't specify are inherited from the Point of View you defined previously, but you can override those Point of View selections by doing one of these tasks:
1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.
2. Click the Member Selector icon to select a member for each of the dimensions listed.
3. Select a dimension in the list, and click the Actions icon to select a member or variable.

Click Next.

On Rounding, complete these steps. The members you select in this step must be a part of the allocation range.

Enter the number of decimal places to use for this allocation, or click the Actions icon to select a member or variable that represents this value.
Select where to place the rounding difference.
1. Select Define location to specify a member or members on which to place the rounding difference. Perform the following steps.
  1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.
  2. Click the Member Selector icon to select a member for each of the dimensions listed.
  3. Select a dimension in the list, and click the Actions icon to select a member or variable.
2. Select Use biggest value to round data values to their largest values.
3. Select Use smallest value to round data values to their smallest values.
4. Select Discard rounding error to use allocated data values as is.

Click Finish.

Scenario