Cell Fixing
Use
To lock input-ready
cells against manual changes in planning applications, you can fix these
cells. Cell fixing is a time-limited setting that only affects the current
user session. Fixed cells are displayed with the standard lock symbol
. The user can also undo cell
fixing.
It can also be a
good idea to fix 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, fixing 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 use cell fixing 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 fixing function. These are local cell fixing in the query (front-end cell fixing) and global cell fixing in a Web template (back-end cell fixing):
Local Cell Fixing in a Query (Front-End Cell Fixing)
Cell fixing is managed exclusively in the BI Java runtime for the current result set. Cell fixings remain in effect so long as no significant changes are made to the result set. The back-end system only recognizes the cell fixings during the server roundtrip and can thus take them into consideration in case of inverse formulas and disaggregation.
Global Cell Fixing in a Planning Application in a Web Template (Back-End Cell Fixing)
Cell fixing is 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 fixed in a query to be displayed as fixed in other queries that belong to the planning application and to be treated as such.
More Information
For more information about the two cell fixing methods, as well as the restrictions and modeling recommendations, see Local Cell Fixing in a Query (Front End) and Global Cell Fixing in a Planning Application (Back End).