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.

When working with input-ready and inverse formulas, it can be a helpful to fix cells (see Input-Ready Queries, Examples: Inverse Formulas and Inverse Formulas).

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 Performing Manual Planning 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).