Turbo Integrator: The Scripting Engine

1 Day Course

Price: $599 USD per student

This course is designed for business modelers seeking to enhance their expertise in Planning Analytics.

Turbo Integrator (TI), the ETL tool within Planning Analytics (TM1), plays a critical role in data integration by facilitating the transfer of data in and out of Planning Analytics (TM1) models, and within and between cubes.

With TI, you can streamline data integration, automate dimension management, and mimic Excel Macro-like functionality to enhance workflows.

Learners will gain hands-on experience building an Income Statement cube and its key dimensions—Departments, Organization, Products, Customers, Accounts, and Time—using CSV files, SQL tables, and manual methods in TI.

Learners will also develop TI processes to create the Income Statement cube, load General Ledger (GL) data from SQL and automate tasks like set creation and hierarchy updates.

Register now!

Contact us to register and schedule training or ask questions about the courses.

Unit 1: What is Turbo Integrator (TI)?

Turbo Integrator Overview   
Turbo Integrator Data Sources         
What Can We Do With TI?    
The Four TI Process Sections

Unit 2: Building Dimensions with TI

The Guided Import Wizard
Writing TI Script Manually    
Ragged vs Balanced Hierarchies    
Multi-level Alternate Hierarchies    
Hierarchy Changes Over Time         
Parent/Child Data Sources 
Flat File Data Sources

Unit 3: Loading Cubes & Other TI Functions

Turbo Integrator as a Scripting Engine        
Loading Cubes with Turbo Integrator          
Key Point Summary