Leaf/Consolidated/String qualifier

In TM1®, there is a distinction between leaf (or numeric) cells, consolidated cells, and string cells.

Leaf (also called 'numeric') cells have coordinates which are all leaf/numeric (N:) elements in their respective dimensions. Consolidated cells have at least one consolidated (C:) element among their coordinates. String cells use a string (S:) element as the last coordinate.

The leaf/consolidation/string qualifier indicates whether, for a defined area, a statement applies only to leaf cells, only to consolidated cells, only to string cells, or (in the absence of a qualifier) to all cells.

If the qualifier is N:, the statement applies to leaf cells only. If the qualifier is C:, the statement applies only to consolidated cells. If the qualifier is S:, the statement applies to string cells only.

If there is no qualifier, the calculation statement applies to all cells in the defined area.

Important: When you use a qualifier, it must immediately precede the formula component of a statement. A qualifier placed at the start of a statement will cause a syntax error.