Show TOC

Back-End Cell LocksLocate this document in the navigation structure

Back-end cell locks in a planning application allow more navigation steps in a query while retaining the cells locks as front-end cell locks. In Analysis, you can decide if the cells are locked for a a single query or multiple queries in a planning application.

Cross query cell locks could be particularly suitable if a planning workbook contains multiple sheets, and its queries are closely linked but are used for different aspects of the planning application.

The back-end cell locks remain in effect if the user performs any of the following activities:

  • Displaying the properties of the dimensions (like Key or Text )

  • Displaying attributes of the dimensions

  • Sorting the result set by dimension members, texts or key figures

  • Swapping row and column axes

  • Expanding or collapsing nodes in hierarchies

  • Hiding/showing structure elements (filter structure elements for example)

  • Adding a dimension to the crosstab: At the lowest point on the right in the rows and the furthest point inside in the columns

  • Removing a dimension from the crosstab: At the lowest point on the right in the rows and the furthest point inside in the columns

Note that some of the operations listed above hide locked cells. This does not undo the cell locks however. These "hidden" cell locks also remain active and are taken into account by the system when calculating inverse formulas and during disaggregation.

If the user performs any of the following activities, all cell locks are undone :

  • Changing the order of the dimensions included in a cell lock

  • Change the axis of the dimension included in a cell lock

  • Changing the settings for BW hierarchies (on/off) for dimensions included in a cell lock,

  • Change the query's dynamic filter (by restricting the variable values without restarting the query for example)

  • Changing the filter using the prompting dialog

  • Performing a planning function or planning sequence