Multiple TM1 Data Source in one Process

There are many types of data sources that TM1 can access.

–          Text File

–          Any database that can connect through ODBC connection

–          ODBO: Cube, Dimension, Mdx Query

–          IBM Cognos TM1: Cube & Dimension Subset

–          SAP: Infocube, Characteristic, Security, SAP table, ODS table, Currency

–          IBM Cognos Package.

Data source can change anytime, from text file to SQL database or anything. Rather than change the Turbo Integrator script, it would be better to keep the setting parameterized.

1. Create a cube to store the setting.
2. The list of process is automatically stored by TM1 in dimension: }Processes
3. Create a list of parameter that required for the general setting of data source
4. Create a cube contain dimension “}Processes” and dimension contain list of parameters setting.

In Turbo Integrator:

1. Define the Variables of data source as usual

2. In Prolog

•   Get the value of parameter setting using CellGet[S/N]
•   Define the setting related to data source type.

3.  Access data as usual

•  The most important thing is data structure must set same for all types of data source.
•  Sample:

In text file data source:

In Sql database or other data source types, you must define the same structure.

Another important tip:

– Do not hard coded User ID and password, if the data source you are using need user ID and password. Especially for password, it is database owner’s right to change the password anytime required.

Imagine if you lost something from your room, where some other people stay with you in one house but different rooms. It is your right to change your room key, no one can say “cannot”.

So whenever database owner change the password, you do not need to modify your script, just change it in the cube setting.

Veronika Rotua Gultom