Creating Dimensions

When you create a dimension, you identify the leaf-level elements that comprise the dimension and, optionally, any hierarchies (consolidations) within the dimension.

There are four ways to create dimensions:

  • Dimension Editor - Add elements as well as create and rearrange consolidations while you design dimensions. For more information, see Creating Dimensions Using the Dimension Editor Window.
  • TurboIntegrator - Import element names from an ASCII, ODBC, cube view, or dimension subset source. Simultaneously create multiple dimensions and establish consolidation within those dimensions. For more information, see TM1 TurboIntegrator.
    Note: TM1 requires DataDirect drivers to access an Oracle ODBC source on Solaris or AIX®. These drivers are not supplied with TM1 and must be acquired separately.
  • Importing Data into a New Cube - Use TurboIntegrator to map input rows from a data source to a cube. Then identify the input columns that supply the cell values and the elements that identify the cell location. For more information about this process, see TM1 TurboIntegrator.