Category Archives: Code Sample – Downloadable

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

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

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

Back to Basics – Regions in Rules

If there is one basic technical best practise which makes TM1 Solutions more straight-forward thus sustainable which is most often not utilised it is #Regions in cube rules. Regions work the same way as grouping rows within Microsoft Excel, except the grouping is done automatically around a set of key words. This is actually a feature in many scripting environments and is called code folding, it is added to a rule like so: #Region *The title … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged Code Folding, Cube Rules, IBM Cognos Express, IBM Cognos TM1, Region, Sales Calculations, TM1 Best Practise, TM1 Cube Rules, TM1 Development. Bookmark the permalink. | Tagged Code Folding, Cube Rules, IBM Cognos Express, IBM Cognos TM1, Region, Sales Calculations, TM1 Best Practise, TM1 Cube Rules, TM1 Development | Leave a comment

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

Rolling Forecast in IBM Cognos TM1

Recently, a client has asked to implement a rolling forecast model to move towards a more dynamic way of forecasting so as the periods move forward so does your forecast so you are always forecasting 12 / 18 months out in to the future. With a rolling forecast the number of periods remain the same so as each period is traded it drops out of the forecast and another period … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, Training Material and tagged Corporate Planning, Forecasting in TM1, IBM Cognos TM1, Rolling Forecasts, TM1 Cube Rules. Bookmark the permalink. | Tagged Corporate Planning, Forecasting in TM1, IBM Cognos TM1, Rolling Forecasts, TM1 Cube Rules | 1 Comment

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