Spreading Values Using Mass Allocation

Data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

Using mass allocation, you can spread data to all descendents of a source cell and across all dimensions. Spreading by mass allocation spreads data to cells not displayed on the grid and does not require that you have access to the target cells.

Mass allocation is available only for forms, which must be enabled for mass allocation by the administrator. You must be provisioned with the Mass Allocate role to use mass allocation.

Note:

Mass allocation cannot be undone.

To spread values by mass allocation:

  1. Put the cursor in the Total or Subtotal cell whose value you want to spread.
  2. From the Planning ribbon, select Adjust, and then Mass Allocate.
  3. Enter a new value in Spread Value to replace the current value, or from the drop-down menu, select one of the following options:
    • Value to increase or decrease values by a specified amount

    • Percentage to increase or decrease values by a percentage

  4. Select Increase By or Decrease By and enter a value or percentage.
  5. In Spread Value, enter the actual spread value that you want.

    For example, if the Current Value is 100 and you want the spread value to be 125, enter 125 directly in Spread Value and do nothing with the Increase By/Decrease By options or text box in step 4.

    Alternatively, you can enter 25 in Increase By, and 125 will be displayed in Spread Value.

    Note:

    Entering a value in Spread Value has no effect on the Increase By/Decrease By text box. But when you enter a value in Increase By/Decrease By, the spread value is reflected in the Spread Value text box.

  6. Select the Spread Type for allocating the specified value or percentage across the target cells:
    • Proportional Spread to spread the value proportionally, based on the existing values in the target cells (the default)

    • Evenly Split to spread the value evenly among the target cells

    • Fill to replace the value in all target cells

    • Relational Spread to spread into the selected cells based on values that exist in a different source location. Selecting this option displays the currently selected members for each dimension in the Selected column.

  7. Click Spread. The new values are automatically saved.