If an administrator assigned the Mass Allocate role to your account in Oracle Hyperion Shared Services, and enabled Mass Allocate property for your forms, you can spread data using Mass Allocate. This feature enables you to:
Allocates data to all the source cell's descendants
Allocates across multiple dimensions
Spreads data even to cells not displayed on the 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 calculation scripts
Executes the calculation scripts against the Essbase server, against all dimension combinations
The Time Balance property setting affects how data is spread with the Fill option. See How Spreading Data Works.
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 then 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 then enter the percent value.
To replace values with a new value, enter it in the Spread Value text box.
|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 that exist 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|