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.