Navigating Allocation
Rule Header
After creating the allocation rule type, the next step is to create a rule header for a specific business scenario. Multiple rule headers can be created to group the detailed allocation rules.
The header contains options to add, edit, copy, and delete rule details.
Rule Details
What makes defining allocation rule details easy is the ability to simplify the definition process. Rule details are divided into three tabs:
General: Captures general information regarding the rule details.
Input: Captures the input dataset information on which the allocation rules are to be applied.
Output: Maintains the output dataset, driver, and offset details to post the results of the allocation.
General
Field |
Purpose |
Values |
|---|---|---|
Description |
Input field to capture the description of the rule details based on its purpose. |
Input text Field |
Allocation Method |
Choose the type of allocation method to apply. |
Dropdown (Driver or Reclass) |
Output Dataset |
The allocation result is posted to this dataset field member. The assigned member should be a base or leaf member. |
Dataset Member Selector |
Dependency |
Applies the dependency of allocation rules when multiple rules are created in the same allocation rule type. |
|
Applicable To |
Version filter on a context selection for executing the calculation. |
Version Member Selector |
Active |
Only active rules are applied. Use the checkbox to enable the calculation. |
Checkbox |
Input
Captures the input details of the dataset on which allocation rules are to be applied.
Fields
A list of fields is auto-populated based on the selected model when creating the action type allocation. The user can select the field members for all fields (except version and time). The user has options to either multi-select members of each field or select a specific member with the applied relationship. If no member is selected, the calculation will consider all or the total of all members' values of the field.
Input Type
Dropdown option for the user to select By Factor or By Value:
- By Factor: Input data is multiplied by this factor. If this option is selected, an additional input field for Allocation Factor is enabled to capture the factor to be multiplied for the input value. By default, a value of 1 is enabled, but the user has the option to increase or decrease the value.
Note: A factor of 1 means 100% of the input value is taken for allocation, whereas a factor of 1.04 means a markup of 4% is applied to the input value. Similarly, a factor of 0.8 means only 80% of the value is allocated, while the remaining balance of 20% is retained in the source dataset.
-
By Value: When this option is enabled, an additional input field for Amount to Allocate is enabled to capture the exact value that needs to be allocated from the source dataset. The system takes the total input data to calculate the factor. Once the factor is calculated, the system will multiply the input data by the factor.
- Factor = Amount to Allocate / Total Input Amount
Output
The output tab consists of three sets of information to be updated.
Allocation Driver Fields
Displays the list of fields from the tagged model selected during rule creation. Each field has three options:
-
Filter: Select specific field members using this option. When selected, a member selector popup window opens for user selection.
Example: You can select specific driver information based on headcount, revenue, units, etc.
-
Match: Checkbox to choose the fields that need to be matched while applying the allocation rule for input and driver information.
The fields selected as matching will be matched with input data for allocation. All other fields will be ignored. To create a table to join with input data, the table will only include fields selected as matched. For matching fields, it is sufficient to filter data for members based on the input filter.
Example: During allocation, input for 2022 should be allocated matching the same time period (2022) for driver information as well.
Allocate: Checkbox to select the field members that are required to be allocated. These fields are retained in the allocation table, and input data is allocated based on the members returned here. A field cannot be set as both allocate and match enabled.
Output
Update list: Option to choose the list of fields to specify the output dataset combination. Once selected, specific members for each field can be chosen to post the output results.
Offset
Same as Source: Input data being allocated (including factor) is multiplied by -1 and posted with the dataset changed to the output dataset.
Not Applicable: Only the output is posted. Offset is not generated.
-
User-Defined:
Dimensions with Update List Selection:
This is a single-select output list for posting results.
Similar to account mapping, which includes the Lookup option.
Input data is overwritten based on these members