Spreading Values Using Mass Allocations

If an administrator assigned the Mass Allocate role to your account in Oracle Hyperion Shared Services and enabled the Mass Allocate property for your forms, you can spread data using Mass Allocate.

Note:

You cannot undo a mass allocation of values.

Note:

The Time Balance property setting affects how data is spread with the Fill option. See How Spreading Data Works.

To spread values using Mass Allocate:

Place the cursor in the Subtotal or Total cell whose value you want to spread.
Select Edit, and then Mass Allocate.
Perform an action:
- To modify values by a specified amount, in Adjust Data, select By Value, select Increase by or Decrease by, and then enter a value.
- To increase or decrease values by a percentage, in Adjust Data list, select By Percentage, select Increase by or Decrease by, and then enter a value.
- To replace values with a new value, enter it in the Spread Value text box.

Select the Spread Type for allocating the specified value or percentage across the target cells, as described in the following table.

Spread Type	Description
Proportional Spread	Spreads the value proportionally, based on the existing values in the target cells (the default)
Relational Spread	Spreads into the selected cells, based on values in a different source location. Selecting this option displays the currently selected members for each dimension in the Selected column. Under Relative, select the members you select that identify the base values to be spread, creating a pattern based on the existing values in the relative cells. To select members, click , and, on the Member Selection page, select members for the dimension, either directly or based on relationships (see Oracle Hyperion Planning Administrator's Guide).
Evenly Split	Spreads the value evenly among the target cells
Fill	Replaces the value in all target cells

Click Spread.