Defining the Cube Data Source

The first step in creating a cube from a text file is to define the data source.

Procedure

  1. In the left pane of the Server Explorer, right-click the Processes icon and select Create New Process.
  2. Click the Data Source tab on the TurboIntegrator window.
  3. Choose Text as the Data Source Type.
  4. Click the Browse button next to the Data Source Name field and select the import_cube.csv file in your TI_data directory. If you accepted the default installation directory, the full path to the TI_data directory is 
    C:\Program Files\Cognos\TM1\Custom\TM1Data\TI_Data
  5. Set the Delimiter Type to Delimited, and choose Comma as the Delimiter.

    Ignore the Quote Char and Number of Title Records fields for this example.

  6. Make sure the Decimal Separator is period (.) and the Thousand Separator is comma (,).
  7. Click Preview to view the first few records of the data source.

    Each record in import_cube.csv contains 6 fields. The first five fields contain information that will be imported into TM1® as element names. The sixth column contains cube data.

    Variable Name

    Variable Type

    Sample Value

    Contents

    V1

    String

    Actual

    Ignore

    Massachusetts

    String

    Argentina

    Ignore

    V3

    String

    S Series 1.8 L Sedan

    Ignore

    Units

    String

    Units

    Ignore

    Jan

    String

    Jan

    Ignore

    V6

    Numeric

    313.00

    Ignore