Allocation How-To Guide
Create an Allocation Rule
Go to Calculations under Drives on the left side panel of the navigation pane.
From the list of Rule Actions, select the newly created Allocation Action Rule Type. Go to the level 2 header and click on the Plus icon to create new Allocation rule group details. A right-side panel of the Allocation Detail will be open.
Enter the Allocation Group Rule Description.
Click Save to save the creation or Cancel to disregard the creation.
Select the newly created allocation group to add more details to the allocation rule. Action icons for Add, Copy, Edit, and Trash will be shown on mouseover.
Click the Plus (+) icon to create the allocation details. The right-side panel of allocation detail will open for the user to populate with the required information.
General Tab:
Go to the General tab and enter the Allocation Description.
From the Dropdown list, select the required Allocation Method; options include Driver and Reclass.
Once the allocation method is selected, activate it by ticking the box for the Intercompany Rule if required. This is optional.
Select the Output Dataset by clicking the Click to Select box. A member selector for the dataset field will open.
Select the specific base or leaf member where the output dataset will be posted.
Click Okay to save the selection or Cancel to disregard the selection.
Optionally, set the dependency by clicking the Dependency box. A selector popover window will open, showing the available allocation details.
Click Insert Items to reflect the selection on the right side of the selector window.
Click Okay to save the selection or Cancel to disregard the selection.
Activate the allocation detail created by ticking the Activate box.
Input Tab:
Go to the Input tab and select the member filter icon for the fields that need to be defined. A member selector window popover will open for selection. Options for multi-select and specific member selection are available, as well as relationships like current member, leaf member, children, descendants, current member and leaf member, current member and children, and current member and descendants.
Click Insert Items to reflect the selection on the right side of the member selector window.
Click Okay to save the selection or Cancel to disregard the selection.
Activate the Apply on Cumulative Data by ticking the box.
Select the required Input Type. Options include By Factor and By Value. When By Factor is selected, the Allocation Factor box will open. Manually enter the allocation factor to be used in the calculation or use the increase/decrease button on the right side of the box. If By Value is chosen, the Amount to Allocate box will open. Manually enter the allocation amount to be used in the calculation or use the increase/decrease button on the right side of the box.
Output Tab:
Go to the Output tab and set the Allocation Driver fields. Enter the Driver Name.
Set the Dimensions. Select the member filter icon for the fields that need to be defined. A member selector window popover will open for selection. Options for multi-select and specific member selection are available, as well as relationships like current member, leaf member, children, descendants, current member and leaf member, current member and children, and current member and descendants. An option to set Allocate or Matching is also available by ticking the required method.
Click Insert Items to reflect the selection on the right side of the member selector window.
Click Okay to save the selection or Cancel to disregard the selection.
Set the Output Dimensions. Click on the Update List to define the fields to be used. A selector window popover will appear with the list of fields. These fields are limited to those defined under the tagged model used in the allocation action rule.
Click Insert Items to reflect the selection on the right side of the member selector window.
Click Okay to save the selection or Cancel to disregard the selection.
Select the member filter icon for the fields that need to be defined. A member selector window popover will open for selection. This is a single-select member, defaulting to the current member only. Only the base or leaf member should be defined.
Click Okay to save the selection or Cancel to disregard the selection.
Click on Advanced Posting Rules if required (optional). A window popover will open to define the required fields' input and output in a table format. If necessary, rows can be added by clicking the Add Row button. Dropdown selection of the members of each field is available on double-click. The user can either use the scrollbar to search for the required member or key in to search for the field members.
Click Okay to save the settings or Back To Field Mapping to disregard the settings.
Set the Offset fields by selecting from the list of options: Same as Source, Not Applicable, or User-defined. Should the user select User-defined, a Dimension selection will be made available for the user to set.
Set the dimensions to be offset. Click on the Update List to define the fields to be used. A selector window popover will appear with the list of fields. These fields are limited to those defined under the tagged model used in the allocation action rule.
Click Insert Items to reflect the selection on the right side of the member selector window.
Click Okay to save the selection or Cancel to disregard the selection.
Select the member filter icon for the fields that need to be defined. A member selector window popover will open for selection. This is a single-select member, defaulting to the current member only. Only the base or leaf member should be defined. An option to set Allocate or Matching is also available by ticking the required method.
Click Okay to save the selection or Cancel to disregard the selection.
Click Save to save the creation or Cancel to disregard the creation. An information popup will appear indicating that the rule detail was saved successfully.
Note: In a member selector or selector popover window, when a previously selected field on the right side is ticked and selected, a trash icon will appear on the upper right side, giving the user the option to delete the selected member.
A new allocation rule with the rule details will then be created.