Exporting Data from a Cube

You can export cube data to a comma-delimited (.cma) text file.

Exporting large cubes can consume significant resources. To address this issue, the Allow Export as Text capability lets the TM1 administrator disable the text export options.

If the Export as Text Data option is disabled in Server Explorer, your administrator has disabled the export capability for your user group. For details on how this capability is set, see Capability Assignments in the IBM Cognos TM1 Operation Guide.

Procedure

  1. In the left pane of the Server Explorer, click the cube containing the data you want to export.
  2. Choose Cube, Export as Text Data.

    The View Extract window opens.

  3. To focus the data that is exported, use the Subset Editor to select only the specific dimension elements that you want to export.

    Click the Subset Subset icon button next to a dimension name to display the Subset Editor and then create a subset for that dimension.

  4. To control which types of values are exported, use the Skip options.

    For details, see Controlling the Types of Values to Export from a Cube.

  5. To export only data that falls within a particular range of values, use the Range parameters and fields.

    For details, see Defining Range Parameters for Exporting Cube Data.

  6. Click Export.

    The Save As dialog box opens.

  7. Navigate to the directory in which you want to save the data and type a file name.
  8. Choose the Encoding format in which to save the file.
    • UTF-8 (8-bit Unicode Transformation Format) - character set with variable-length character encoding for Unicode.
    • ANSI - ANSI character set.
    Note: The UTF-8 option creates the exported file with character encoding for Unicode that is able to represent any universal character in the Unicode standard. Use the UTF-8 option if your cube data includes a mix of character sets that the ANSI option would not be able to correctly represent.
  9. Click Save.