Tag Archives: Turbo Integrator

Transfering Data between TM1 Servers using ODBO (i.e. Without CSV's)

This blog shows the steps needed to establish an ODBO connection in order to  transfer data between 2 cubes in different server instances.

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 10.2, Training Material and tagged Datasource, ODBO, TM1, Turbo Integrator. Bookmark the permalink. | Tagged Datasource, ODBO, TM1, Turbo Integrator | 3 Comments

Managing Applications from Command Line

In 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 overnight application maintenance. This … Continue Reading

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 Modeler, 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

Testing Turbo Integrator Code

Calculated Variable Formula Window

In the last post we talked about how we can output String and Numeric values in a Fixed Width Field Format. I realised just after writing the article that I used a not-well-known trick in order to perfect the snippets I posted. This is: Using Calculated Variables to Test Field Calculations. I’m going to use the example of the numeric field from the last post to present how to better … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, Training Material and tagged IBM Cognos Express, IBM Cognos TM1, Scripting, Turbo Integrator. Bookmark the permalink. | Tagged IBM Cognos Express, IBM Cognos TM1, Scripting, Turbo Integrator | Leave a comment

Fixed Width File Format from TM1

When outputting data from TM1 usually we can get away with comma separated values format. Which is standard functionality from a Turbo Integrator process [See ASCIIOutput, TextOutput functions]. Every now and then we need to interface with a ERP system which requires Fixes Width Fields. This presents a few problems, not insurmountable but still not expressly easy either. The tips below will make things easier for you. ASCII Quote Character Options To start your extract process … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator. Bookmark the permalink. | Tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator | Leave a comment

Notepad++ for TM1 Rules & TI – Updated!

With the new release of Notepad++ yesterday to v6.4.1, I thought it was a brilliant time to update the TM1 Turbo Integrator and Rules Syntax files to be based on TM1 v10.1.0 Reference Guide. The new version xml file can be found here: TM1 v10.1 Notepad++ update In this release, we’ve added a couple of new TI functions such as: Synchronize: Used in a TI script to force serial execution of … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, TM1 10.1, TM1 pre 10.1, Training Material and tagged Code, IBM Cognos Express, IBM Cognos TM1, Notepad++, Rules, Syntax Highlighting, Turbo Integrator. Bookmark the permalink. | Tagged Code, IBM Cognos Express, IBM Cognos TM1, Notepad++, Rules, Syntax Highlighting, Turbo Integrator | 10 Comments

Woohoo! TM1 Tuts has cracked 100,000 visits!

This is just a shout out to all the administrators, support teams and developers who have browsed or subscribed to the TM1 Tutorials blog over the last two years. Thanks, your the best and we are so pleased to have the opportunity to share our time tested tips and tricks with you all If you are new to TM1 Tutorials, take a moment to read through the topics we have covered … Continue Reading

This entry was posted in Bug Fix, Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 Contributor, TM1 pre 10.1, Training Material and tagged Cognos TM1, Feeders, IBM Cognos TM1, Rule Feeders, Turbo Integrator. Bookmark the permalink. | Tagged Cognos TM1, Feeders, IBM Cognos TM1, Rule Feeders, 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

Turbo Integrator Syntax Highlighter (Notepad++)

It is no secret that syntax highlighting script editors increase developer productivity. I regularly find myself staring at a chunk of TI processes (especially those written by someone else) for far too long. The combination of black and white text with small, crowded fonts in Turbo Integrator doesn’t help with the readability at all. While Notepad++ is a great tool for text and script editing, unfortunately it doesn’t support TM1 … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged IBM Cognos TM1, Notepad++, Syntax Highlighter, TM1 Development, Turbo Integrator. Bookmark the permalink. | Tagged IBM Cognos TM1, Notepad++, Syntax Highlighter, TM1 Development, Turbo Integrator | 7 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