Defining a Data Source

Whenever you use TurboIntegrator, the first step requires you to define the data source from which you will be reading data. This example defines the ASCII file called NewEngland.cma as the data source for this TurboIntegrator process.

Procedure

  1. Right-click Processes in the left pane of the Server Explorer and choose Processes, Create New Process.
  2. Click Text on the Data Source tab.

    The TurboIntegrator window opens.

  3. Click Browse.

    The Select Input File dialog box opens.

  4. Navigate to NewEngland.cma, select it, and click Open.

    NewEngland.cma is available in either the PData or SData sample data directory. If you accepted the default installation directory for TM1® , the full path to the file is 

    C:\Program Files\Cognos\TM1\Custom\TM1Data\SData\NewEngland.cma

    or 

    C:\Program Files\Cognos\TM1\Custom\TM1Data\PData\NewEngland.cma.

    You may receive a message indicating that you should use Universal Naming Convention (UNC) to specify the file location. If you are going to consistently run your process against an ASCII file, you should use UNC and ensure the following:

    • If running a Microsoft Windows TM1 server, the ASCII file should reside on a shared Windows directory so that the server can access it.
    • If running a TM1 server on a UNIX operating system, your file should reside on a shared network directory, one which both the TM1 Windows client and the TM1 UNIX server can see.

    Note: If running aTM1 server on a UNIX operating system, the input source filename cannot contain any upper-case characters or spaces.

  5. Click OK on the warning box.
  6. Complete the TurboIntegrator dialog box as follows:

    NewEngland.cma is a delimited source that uses commas as its delimiter; double quote as a quote character; no title records; a period as a decimal separator; and a comma as a thousands separator.

    To define this source enter the following settings:

    • At Delimiter Type, select Delimited.
    • Select Comma as the Delimiter.
    • Enter " at Quote Char.
    • Leave the Number of Title Records field blank.
    • Enter . at Decimal Separator.
    • Enter , at Thousands Separator.
  7. Click Preview.

    TurboIntegrator shows you a sample of your source data at the bottom of the window.