Spreading Data with Cell Locking

Data source types: Planning for Oracle Planning and Budgeting Cloud Service

If you are unfamiliar with Planning for Oracle Planning and Budgeting Cloud Service, see the Oracle Hyperion Planning User's Guide, available on the Oracle Cloud help center.

When spreading data over time periods, you can temporarily lock the values of one or more cells to preserve their values when other values are recalculated. You can spread data across time periods based on various calculations and visually review the changes before committing them to the database. For examples of spreading with cell locking, see the Oracle Hyperion Planning User's Guide.

  To temporarily lock values:

  1. Open a form.

  2. In the form, select the cell or group of cells that you want to lock.

  3. From the Planning ribbon, select Lock.

    A color change indicates that a cell is locked. You can now spread or manipulate data in the other cells however you want, without affecting the locked cells.

  4. To unlock a cell, refresh the grid.

Related Topics:

Spreading Data for Time Periods

Spreading Values Using Grid Spread

Spreading Values Using Mass Allocation