If you have the Mass Allocate role (assigned in Oracle's Hyperion® Shared Services) and an administrator has enabled Mass Allocate as the data form property, you can spread data using the powerful feature, Mass Allocate, which:
Allocates data to all the source cell's descendants
Allocates across multiple dimensions
Spreads data even to cells not displayed on the data form
Does not require that you have access to the target cells
Cannot be undone after you mass allocate values
Is processed with dynamically-created calc scripts
Executes the calc scripts against the Essbase server, against all dimension combinations
Can use customized spreading patterns, created by an administrator (see the Oracle Hyperion Planning Administrator’s Online Help)
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:
Put the cursor in the Subtotal or Total cell whose value you want to spread.
To increase or decrease values by a specified amount, from the Adjust Data drop-down list, select By Value, select Increase by or Decrease by, and enter the value to spread.
To increase or decrease values by a percentage, from the Adjust Data drop-down list, select By Percentage, select Increase by or Decrease by, and enter the percent 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.
Your administrator can add other spreading patterns, described in the Oracle Hyperion Planning Administrator’s Online Help.
The new values are automatically saved in Essbase.