Spreading Data with Cell Locking

Data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

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:

Open a form.
In the form, select the cell or group of cells that you want to lock.
From the provider 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.
To unlock a cell, refresh the grid.