Spreading Values Using Grid Spread

Data source types: Oracle Hyperion Planning

If you are unfamiliar with Planning, see the Oracle Hyperion Planning User's Guide, available in the Oracle Help Center. To open this library, from the Smart View ribbon, select the arrow next to Help, and then Documentation.

If your administrator has enabled Grid Spread, you can specify an amount or percentage to increase or decrease values across multiple dimensions on the grid, based on the existing values in the target cells. When calculating the spread data, read-only and locked cells and cells having supporting detail are ignored. Data integrity is ensured because values can be spread only to cells to which you have access.

To spread values using Grid Spread:

  1. Put the cursor in the Subtotal or Total source cell whose value you want to spread to target cells.
  2. From the Planning or Planning Ad Hoc ribbon, select Adjust, and then Grid Spread.
  3. From the drop-down menu, select one of these 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 a spreading pattern:
    • 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

    Your administrator can add other spreading patterns.

  7. Click Spread. The specified value or percentage is spread across the target cells, replacing former values with new ones.
  8. To save the new values, click Save.