Building the MDX TurboIntegrator Process

When you have an MDX statement that returns useful data, you can build your TurboIntegrator process by following these steps.

1. In the Server Explorer, right-click Processes and choose Create New Process. The TurboIntegrator window opens.
2. In the Data Source Type box, click ODBO and select MDX Query.
3. Enter required connection parameters in ther Connection tab of the TurboIntegrator window. The connection parameters are vendor-specific.
4. Click Connect. If you connect successfully, the Connect button becomes greyed out and you are able to proceed to the MDX Query tab.
5. Click the MDX Query tab.
6. Type your MDX query into this tab. You can also cut a working MDX query from another application and paste it into this tab.
7. Click the Variables tab. For each column generated by the MDX statement, one variable is generated by TurboIntegrator.

   Columns containing row headers are typically mapped as dimension elements. Columns containing data elements are mapped as data.

8. See "Mapping Variables" to map the variables into TM1® structures. Once you have connected to the ODBO data source and defined the MDX statement, the process for completing the TurboIntegrator process is identical to that of an ODBC data import.