Tag Archives: TurboIntegrator

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

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

Creating a Time Dimension

This post should really be titled “Creating a Time Dimension with a method which allows it to be easily expanded later.” but that simply wont fit. The concept is simple, where previously a time dimension is manually updated and eventually becomes tiresome to update (once every few years) we can instead use one process to create the dimension and for each year call another process which added the year its … Continue Reading

This entry was posted in Code Sample - Downloadable, IBM Cognos TM1, TM1 pre 10.1, Training Material and tagged Code Download, DimensionElementComponentAdd, DimensionElementInsert, IBM Cognos TM1, TI, Time Dimension, TurboIntegrator. Bookmark the permalink. | Tagged Code Download, DimensionElementComponentAdd, DimensionElementInsert, IBM Cognos TM1, TI, Time Dimension, TurboIntegrator | Leave a comment

How to Import all Files in a Directory

We’ve recently been on a Property Management project using TM1 to deliver a Management, Planning and Reporting Solution. The Client has properties which are managed by an external property manager who produces tenancy schedules and general ledger reports for data consumption. The Problem: Every properties reports would come from the external property manager in a different file. Making the process to load these into TM1 only mildly faster than using … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged ExecuteCommand, ExecuteProcess, IBM Cognos TM1, TI Process, TurboIntegrator, VBScript. Bookmark the permalink. | Tagged ExecuteCommand, ExecuteProcess, IBM Cognos TM1, TI Process, TurboIntegrator, VBScript | 2 Comments

Nightly TM1 Backups

All data pertaining to a TM1 server is typically held in a single folder we call the Data Directory. We recommend you backup this folder at the very least weekly. Although most servers have automatic backups owned by the IT Department it can be beneficial to have an archive backup (*.zip file) taken regularly which enables (subject to licenses) a TM1 Administrator to run a backup in parallel with their production server … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged 7-Zip, Backup Process, IBM Cognos TM1, Nightly Backups, TI Process, TM1 Archive, TM1 Backup, TM1 Command Line, TurboIntegrator. Bookmark the permalink. | Tagged 7-Zip, Backup Process, IBM Cognos TM1, Nightly Backups, TI Process, TM1 Archive, TM1 Backup, TM1 Command Line, TurboIntegrator | 2 Comments