Using TurboIntegrator, you can import data from the following data sources:
Industry standard comma-delimited (CSV) text files including ASCII files
Information stored in relational databases (accessible through an ODBC data source)
Other OLAP cubes, including Cognos TM1 cubes and views.
Microsoft Analysis Services
SAP via RFC, creating TI processes
TI's basic object is the process, which can be created by an administrator. Multiple processes can be linked together as chore objects, which allow the processes to be executed in sequence as well as to schedule processes to run for a specific time and/or interval. More recent versions of TM1 also allow processes to be called from other processes, allowing a non-sequential execution path.
To create a new TI script you can use TM1 Server Explorer. You have to just right-click on Processes and then select Create New Process. TM1 then opens the TurboIntegrator dialog showing a new, blank process ready for...