The Run Unallocated Difference calculation workflow task generates the unallocated differences for other dimensions, such as Cost Centers, Divisions, Product, Business Unit, among others, or the Intercompany dimension.
Before you create the workflow task, review the Run Unallocated Difference calculation.
To create the Run Unallocated Difference calculation task:
- Create a workflow process that includes a Calculation task.
- Type a name for the workflow task, such as Run Unallocated Difference.
- Select Stored Procedure for Type and appdb for Datasource.
- Type fl.UnallocatedDifference for the Stored Procedure Name.
- Create seven parameters:
- Select New Parameter and type User for the Name and {User} for the Value.
- Select New Parameter and type Model for the Name and type {Global.NAMEOFMODEL} for the Value. Replace NAMEOFMODEL with the name of your model.
- Select New Parameter and type Scenario for the Name and type {ProcessParameter.Scenario.Name} for the Value.
- Select New Parameter and type Date for the Name and type {ProcessParameter.Period.Name} for the Value.
- Select New Parameter and type Entity for the Name and type {ProcessParameter.Entity.Name} for the Value.
- Select New Parameter and type NoDimensionDetailMode for the Name and type 1 for the Value.
- Select New Parameter and type Periodic for the Name and 0 for the Value.
- Specify the Timeout and select the Advanced Rule option.
- Select OK.