Creating a Cube from a Text File

TurboIntegrator can also create an entire cube from a text file. This procedure also builds some dimensions and elements, and performs some data manipulation.

The procedure for building a cube is similar to the process for building a dimension:

  1. Define the data source to TM1® . See Defining the Cube Data Source.
  2. Identify the variables TM1 will encounter. See Defining Cube Variables.
  3. Map the different variables to their different data types in the resulting cube. See Mapping Cube Element Variables to Dimensions, Mapping Cube Data Variables,Mapping Cube Variables, and Mapping Consolidation Variables.
  4. Save the process and run it. See Saving and Executing the Cube Process.

TM1 includes a sample data directory called TI_data. TI_data contains a file called import_cube.csv. This example describes how to build a cube from import_cube.csv.