Category Archives: TM1 pre 10.1

Neglected Functionality – Custom Rollups & Subset Consolidations

In this blog segment, we’ll look at value add features of the IBM Business Analytics software which are often overlooked and underused. In this article I’m going to explain Custom Rollups and Subset Consolidations within IBM Cognos TM1. Custom rollups are used to create a temporary user-defined consolidation element. It is a very useful, but somewhat underused functionality. With custom rollups, you won’t be able to save the subset but … 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 Cube View, Cube Viewer, Custom Rollup, IBM Cognos Express, IBM Cognos TM1, Subset Editor, Tips and Tricks, Training. Bookmark the permalink. | Tagged Cube View, Cube Viewer, Custom Rollup, IBM Cognos Express, IBM Cognos TM1, Subset Editor, Tips and Tricks, Training | 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

InfoCube Spark – An Introduction

In 2005 Google Launched Google Analytics – a platform for analyzing website traffic by geography, source, keywords and 114 other dimensions. This free value-add platform is now used in 55% of the top 10,000 websites and used by 55% of fortune 500 companies who quickly realized that more timely insights which are more widely accessible drives greater response time and better ability to avoid problems before they occur. I’ve often … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, CubeSpy TM1 Server Monitor, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged IBM Cognos, IBM Cognos TM1, InfoCube Spark, Server Logs, Software, Spark, TM1 Top, TM1 Training. Bookmark the permalink. | Tagged IBM Cognos, IBM Cognos TM1, InfoCube Spark, Server Logs, Software, Spark, TM1 Top, TM1 Training | 2 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

Your Lifeline, The TM1 Transaction Log

Super-Undo – backing out transactions in TM1 is not at all difficult. First of all here is the view of the Salary cube with data: And one after the data is accidentally flushed out: There are 2 ways to navigate to the Transaction Log window through TM1 Perspectives: Click on your Server name from the list and Click Server > View Transaction Log Right click on your server name and … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged Architect, Backing Out Changes, IBM Cognos TM1, Perspectives, TM1, Transaction Log. Bookmark the permalink. | Tagged Architect, Backing Out Changes, IBM Cognos TM1, Perspectives, TM1, Transaction Log | 1 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

Broken Transaction Log?

With Windows Vista, 7 and many of the newer server editions of Windows a Microsoft security fix has removed a component which TM1 Perspectives & Architect use to display the Transaction Log browser.  This component is called “MSMask32.ocx” which traditionally belongs in the System32 folder. To get this working again on these machines: Download the component here: msmask32.zip Save these to the appropriate folder below: On a 32-bit computer save to C:\Windows\System32\ On … Continue Reading

This entry was posted in Bug Fix, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged Bug, IBM Cognos TM1, Transaction, Transaction Log. Bookmark the permalink. | Tagged Bug, IBM Cognos TM1, Transaction, Transaction Log | 1 Comment

Removing old TM1 Servers from "Services"

When upgrading a clients environment to IBM Cognos TM1 10.1 I noticed a bunch of older TM1 Services. A quick google reveals that you can remove services by using the following command line: sc delete “Service Name” Note: If you have a TM1 Service setup as: “TM1 Server x64 / Production Server” you will use the following command sc delete “Production Server” Is it about time you cleaned up the … Continue Reading

This entry was posted in TM1 10.1, TM1 pre 10.1 and tagged IBM Cognos TM1, Install, Installation Guide, NT Service, TM1, TM1 Installation. Bookmark the permalink. | Tagged IBM Cognos TM1, Install, Installation Guide, NT Service, TM1, TM1 Installation | 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