Show TOC

Defining Cell ReferencesLocate this document in the navigation structure

You can use a reference cell to reuse the implicit cell definition in a formula, without needing to manually create this value by using a new selection.


You have a query with two structures and you want to reuse the value of the implicitly generic cell definition, which is created at the intersection of two structure elements.


  1. Select the required cell in the Cells screen area.
  2. Open the context menu and choose New Reference Cell. A description based on the two structural components now automatically appears in the cell. The symbol shows you that this exception cell is a reference cell.
  3. Specify the properties of the reference cell in the Properties screen area.
    • On the General tab, you can change the technical name, description and display properties of a defined exception cell.

    • On the Calculations tab, you can specify local calculations.

    • On the Planning tab, you can make the cell input-ready.