Tag Archives: TI Process

Using the DimensionCreate Function to Create a Dimension in TM1

To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

Checking if a DimensionExists in a TM1 Model

To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

“Joining” Text Files in a TM1 Turbo Integrator Process

How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.

This entry was posted in Attributes, Data Connection, TI Data Sources, TI Processes and tagged Attribute, Dimension, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Attribute, Dimension, TI Process, Turbo Integrator | Leave a comment

Data Export Tool Review – Flyspeed

Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this relevant for me? Well, Visual Foxpro is a very close relative of dBase – a … Continue Reading

This entry was posted in Data Connection, Planning Analytics, TI Data Sources and tagged ETL, TI Process, Turbo Integrator, TurboIntegrator. Bookmark the permalink. | Tagged ETL, TI Process, Turbo Integrator, TurboIntegrator | Leave a comment

Managing Applications from Command Line

Managing TM1 Applications from a command line, or via a Windows batch file. In other words using the TM1 windows based utility “app_maintenance.bat” to execute TM1 processes from Windows.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged App Maintenance, Application Maintenance, Business Analytics, Commandline, TI, TI Process, TM1 10.2, Turbo Integrator. Bookmark the permalink. | Tagged App Maintenance, Application Maintenance, Business Analytics, Commandline, TI, TI Process, TM1 10.2, Turbo Integrator | Leave a comment

TM1 10.2 – New Feature: Enable/Disable Applications from Commandline

In this new release of TM1 10.2, a new feature has been added to allow users to perform application maintenance using command line, or in a batch file. The main purpose of this utility is to automate some of the application maintenance, using a combination of standard TI processes and TI processes that execute commands available in this utility.  Also, chores can be setup to execute these periodically, such as … Continue Reading

This entry was posted in IBM Cognos TM1, Performance Modeller, TM1 10.2 and tagged App Maintenance, Application Maintenance, Business Analystics, Commandline, TI, TI Process, TM1 10.2, Turbo Integrator. Bookmark the permalink. | Tagged App Maintenance, Application Maintenance, Business Analystics, Commandline, TI, TI Process, TM1 10.2, Turbo Integrator | Leave a comment

How to write easily understood Turbo Integrator code

As many of TM1 consultants know, reading TI code always has the possibility of being a tricky task – especially if it is someone else’s code. This is mostly due to TM1 Perspectives Turbo Integrator lacking Syntax Highlighting (See our Notepad++ highlighter) but in part it is due to poor variable naming, indenting, casing or things simply not developed consistently throughout the model.

This entry was posted in IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged IBM Cognos TM1, TI Process, Turbo Integrator, TurboIntegrator. Bookmark the permalink. | Tagged IBM Cognos TM1, TI Process, Turbo Integrator, TurboIntegrator | 4 Comments

Automating Data Transfers between TM1 Servers

Replicating a Cube from a one TM1 Server into another has never been easier. Follow the steps below to copy a cube from one server to another (this includes synchronising TM1 Dimensions). This process uses the ODBO Provider for TM1 and generated MDX. I was going to show how to create an MDX Query for the desired cube but as it turns out you can select ODBO Cube as the data type … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged ETL, ExecuteProcess, IBM Cognos, IBM Cognos Express, IBM Cognos TM1, TI Process, TM1 Training, Turbo Integrator. Bookmark the permalink. | Tagged ETL, ExecuteProcess, IBM Cognos, IBM Cognos Express, IBM Cognos TM1, TI Process, TM1 Training, Turbo Integrator | 7 Comments

TM1 Contributor – Single Security Hierarchy

Currently on-site at client installing TM1 Cognos Express. The client wishes to use the contributor application to utilize workflow in the forecast. Doing so can creates a number of limitations, namely security and secondly cube design. Within TM1 Contributor/Cognos Express Planner you apply security based on a single dimension hierarchy for the application you have created, however the elements within the entire security dimension cannot share more than one top … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 Contributor, TM1 pre 10.1, Training Material and tagged Contributor, David Payten, ETL, Fluffy Mittens, IBM Cognos TM1, Sample Code, TI Process, TM1 Process, TM1 Tutorial. Bookmark the permalink. | Tagged Contributor, David Payten, ETL, Fluffy Mittens, IBM Cognos TM1, Sample Code, TI Process, TM1 Process, TM1 Tutorial | 1 Comment

Sending Emails from TM1 (Part 2: HTML)

Sending Emails from TM1 – Using HTML Problem: Although some additional components of TM1 have built-in email functionality, TM1 does not have email functionality built into its ETL Engine. Text emails will not suffice, you want to employ HTML encoding in your email to provide a more ascetically appealing email. Solution Process: Within a TI Process output text to a file to be used as the body of the email … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Email, IBM Cognos TM1, SMTP, TI Process. Bookmark the permalink. | Tagged Email, IBM Cognos TM1, SMTP, TI Process | 4 Comments