TM1 Turbo Integrator is an ETL (extraction – transformation – loading) tool. In simpler terms, it can extract data from various data sources and load into TM1 cubes. But data loading is one of the so many things that TI is capable of.

A large number of capabilities make TI an integral part of TM1 offering. You can:

Create dimensions and cubes

Run other TI processes

Do data spreading

Apply security

Do almost anything that you do manually, using TI.

We’ve already covered the basic data loading part in our rules tutorial. So in this tutorial, I’ll cover the dimension creation using TI. This will introduce you to the various components of TI. We’ll create the ‘Location’ dimension.

Before we go any further, let’s first create the text file that we’ll use to create the dimension.

Location,Country,Total World,Continent,LocationCode
Newyork,USA,Total World,NA,954821
Austin,USA,Total World,NA,954823
Bangalore,India,Total World,Asia,125433
North Carolina,USA,Total World,NA,954824
San fransisco,USA,Total World,NA,954822
Tokyo,Japan,Total World,Asia,235432
Mumbai,India,Total World,Asia,125432
Sydney,Australia,Total World,Aus,456321
Shanghai,China,Total World,Asia,765354

First row of data contains the column heading. First 3 columns of data are self-explanatory. The fourth column is the continent value. We’ll use it as the attribute of dimension elements. The fifth column is location code. This will be a numeric attribute. This will represent the location code of a particular location.

NOTE: Before proceeding any further, save and close your text csv (Locations.csv) file.

Creating Process

Open architect, expand nodes and right click on Processes. Click Create new process. Doing this will launch the TI editor.

1. Select Data source

On the first tab, you can select data source. There are various types of data sources here, for now we’ll use the text. Select your text file using Browse button on the page (in front of the data source name). If a warning appears, just click OK.

Input Number of title records as 1 and click Preview.

2. Select Variables

Go to the variables tab and rename V3 as vTotalWorld. Under Contents column, set

Location – Element
Country – Consolidation
vTotalWorld – Consolidation
Continent – Attribute
Location Code – Attribute

3. Map Variables

Go to the next tab. In cube tab, do nothing. That’s because we’re just going to create the dimension not the data loading. Go to dimension tab. In Action, select Create. In dimension column, write our dimension’s name Locations. Element type will be numeric and element order will be automatic sort by Hierarchy

As there are no data variables, data tab will be disabled. Come to consolidations tab. Here we will set the hierarchy.
Each location’s parent -> Country
Each Country’s parent -> Total World

Click on black sign under child variable and set the values as below

Set the component order too ‘by Name’.

Go to Attributes tab and set subsequent values. Under attribute, you’d have to manually type the name of new attributes. You will be able to select the remaining values by clicking.

4. Review the Auto Generated Code

Go to the advanced tab and one by one select and review the auto generated code. Doing so is mandatory after every change to the TI process. Now save the process and click Run. The process will complete successfully. The location dimension has been created.

Verify the Process Changes

Now go to the dimension’s node in Architect and double click Locations. You should see subsequent hierarchy.

Also, verify the created attributes. Right click the Locations dimension in Architect and select ‘Edit element attributes…’. You will see the attributes that we have created.

Assignment

Edit the above process and create one alias attribute which should have values in subsequent format:
LocationCode – Location

So alias value for element Newyork will be 954821 – Newyork

I’ll put the solution in the comments section.

This concludes our article on TM1 Turbo Integrator.

For Turbo Integrator functions reference, refer to the subsequent IBM link:

http://publib.boulder.ibm.com/infocenter/ctm1/v9r4m1/topic/com.ibm.swg.im.cognos.tm1_ref.9.4.1.doc/tm1_ref_id13598TM1TurboIntegratorFunctions_N70006.html

So, this brings us to the end of blog. This Tecklearn ‘Cognos TM1 Turbo Integrator’ blog helps you with commonly asked questions if you are looking out for a job in Cognos TM1. If you wish to learn Cognos TM1 and build a career in Business Intelligence domain, then check out our interactive, Cognos TM1 Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/cognos-tm1/

Cognos TM1 Training

About the Course

Tecklearn’s Cognos TM1 training will make you proficient in building and configuring models in Cognos TM1 using performance modeler tool. Some of the topics included in this Cognos TM1 training are creation and configuration of TM1 servers, building Cubes and Views, creating dimensions, deploying Turbo Integrator for loading and maintaining data and transferring data using scripts. etc., in working with real-time projects, and this will enable you to become a certified Cognos TM1 developer.

Why Should you take Cognos TM1 Training?

The Average salary for a Cognos TM1 Developer is $117,816 per annum – ZipRecruiter.com.
Cognos TM1 has a market share of about 11.87%.
Solution that is owned by Financial and Business analysts, with limited IT involvement, but consistent with IT’s governance.

Curriculum

Introduction to Cognos TM1

Concepts of Multi-dimensional OLAP database
Cognos TM1 Installation
TM1 Servers and Services
TM1 Workflow
TM1 User Interfaces
Turbo Integrator

Cognos TM1 Configuration

Managing TM1 Components and Tasks
Operations on TM1 Servers: Start, Stop and adding TM1 Servers
TM1 Web, Applications and Operations Console
Using Command prompt create or delete Desktop/Windows services
Hands On

Creating Dimensions

Manual creation of Dimensions
Create Product Dimensions and Measure Dimensions
Dynamic Subset Creation
Sparse and Dense Dimensions
Using Turbo Integrator ETL create cubes, review Cubes and Dimensions
Create Subset, assign Subset, Dimensional Manipulation
Performance Monitoring
Control Cubes
TM1 Web and Rules in TM1
Cube related attributes, dimension related attributes
Hands On

Building Cubes and Views

Building Cubes
Building Views
Bulk Load Mode
Creating Data Source through TM1 Turbo Integrator
Hands On

TM1 Security

Various security levels including Server level, Cube level, Dimension level
Concepts of Security in TM1
Creation of Client & Group and access privileges
Cube Level Security
Hands On

TM1 Data Spreading

TM1 Data Spreading and Recreating dimension
Attributes element types
Cube control elements
Dimension elements
Drill Assignment rules
Trace a feeder and feed strings
Hands On

Cognos TM1 Rules

Understanding TM1 rules
TM1 Rules Editor and Rules compilation using functions
Rule performance optimization
Element information rules functions
Cube manipulation Turbo Integrator functions
D-type in TM1
ELCOMP & ELISCOMP Functions
ELISPAR & ELWEIGHT Functions
Hands On

Advanced Scripting with Turbo Integrator

Advanced Scripting with Turbo Integrator
Deploying Dimension subsets and attributes
Editing procedures using scripts
Hands On

Advanced Modelling Techniques

Significance of advanced modelling
Manually adding objects to application design
Understanding application views, dimensions and hierarchy
Virtual cubes, Lookup cubes and spread profile cube
Hands On

TM1 Application Web

TM1 Web Applications
Creating TM1 Application
Working with TM1 Application Web
Snapshots in TM1 application
Adding MDX filters and Action button properties
Active forms, TM1 user and data formatting range
Hands On

635