Dimensions are made up of elements. TM1 currently supports three types of elements:
Element |
Description |
---|---|
Numeric |
Numeric elements identify the lowest-level detail in a dimension. In a cube that contains only numbers, TM1 defines all the lowest-level elements as numeric. |
Consolidated |
Consolidations are aggregations or rollups of lower-level detail elements. |
String |
String elements store text strings in the cells. To include a string in a cell in a cube, the element from the last dimension defining the cell must be a string element. TM1 treats string elements that occur in any dimension other than the last one as numeric elements. |
Key points are numeric elements which can be referred to as simple element types and identify the lowest level in a dimension hierarchy and consolidation elements. They are created strictly to calculate an aggregation.