Show TOC

Cell, Exception Cell and Help CellLocate this document in the navigation structure

The definition of a cell arises from the intersection of two structural elements from different structures. This implicit cell definition can be overwritten by an explicit definition. This defines an exception cell. You can add one or more help cells to an exception celll.


If you use two structures in a query, the system implicitly creates a generic cell definition at the intersection of two structural elements, thus defining the value to be presented in the cell.

Exception Cell

Cell-specific definitions allow you to define formulas and selection conditions for cells, thus overwriting the implicitly created cell values. You can create precisely one such explicitly defined exception cell for each cell. Exception cells allow you to design queries with a much higher degree of detail.


Note that using exception cells can significantly increase the time it takes to execute your query.

You have the following options when defining an exception cell:

  • As a reference cell that is used in an exception cell that is defined as a formula or selection,

  • As a formula

  • As a selection

The properties of an exception cell correspond to those of the corresponding structural element (formula or selection). To define how an exception cell is displayed, you can make settings that deviate from those in the column where the cell is situated.

Help Cell

You can also define one or more help cells for a cell. These do not have any direct connection with the corresponding structural elements. These cells are not displayed. They are used for help selections and for help formulas.

You have the following options when defining a help cell:

  • As a formula

  • As a selection