Cell Locks
Use
You can lock
input-ready cells against manual changes in planning applications. A locked
cell is a time-limited setting that only applies to the current user session.
Locked cells are displayed with the standard lock symbol 
. The user can also undo cell locks.
It can also be a
good idea to lock cells when working with input-ready and inverse formulas
(see
Input-Ready
Queries,
Examples: Inverse
Formulas and
Inverse Formulas at
Runtime).
If disaggregation
is used in a query, locking a cell can help you to fix the values of higher or
lower levels while manually changing other values (see Planning Business Data
Manually and
Disaggregation
(Top-Down-Distribution)).
If you lock cells in an input-ready query for disaggregation, we recommend modeling hierarchical relationships by exclusively using BW hierarchies or subtotals and totals in characteristics in the drilldown. You should not use structure elements defined as hidden “hierarchies” in Query Designer for modeling.
Integration
There are two implementations of the cell lock function. These are local cell locks in the query (front-end cell locks) and global cell locks in a Web template (back-end cell locks):
Local Cell Locks in a Query (Front-End Cell Locks)
Cell locks are managed exclusively in the BI Java runtime for the current result set. Cell locks remain in effect so long as no significant changes are made to the result set. The back-end system only recognizes cell locks during the server roundtrip and can thus take them into consideration in case of inverse formulas and disaggregation.
Global Cell Locks in a Planning Application in a Web Template (Back-End Cell Locks)
Cell locks are managed exclusively in the back-end system for all input-ready queries in the planning application. This makes it possible for a cell that is locked in a query to be displayed as locked in other queries that belong to the planning application and to be treated as such.
More Information
For more information about the two cell lock methods, as well as the restrictions and modeling recommendations, see Local Cell Locks in a Query (Front End) and Global Cell Locks in a Planning Application (Back End).