In this chapter, we have discussed some of the more advanced Cognos TM1 TurboIntegrator scripting techniques that you will need to know and be comfortable with before taking the current IBM Cognos TM1 Developer (Test COG-310) certification exam. We have also looked at some practical examples.
There are some important points you should know:
The current certification exam assigns a weightage of 10 percent to the Advanced Techniques for TI Scripting topic.
ETL is an acronym for extract, transform, and load.
TM1 TurboIntegrator is the programming or scripting tool that allows you to automate data importation, metadata management, and many other tasks.
Scripts built with TI, can be saved, edited and, through the use of chores, be set up to run at regular intervals.
TI scripts can be used to process existing TM1 data or, through the use of TI's Data Source feature, import (and then process) data or information external to TM1.
Within each process there are six sections or tabs...