Creating basic Top 10 reports using MDX expression

One of the most common requests for reports is to generate a list of top 10 for a dimension based on TM1 data. This makes sense considering level of data TM1 works best with; this could cover top 10 consumers, customers or top 30 SKUs at one particular outlet or within a brand. There are several ways to achieve that within TM1, the simplest way to do this within a … Continue Reading

This entry was posted in IBM Cognos TM1, Training Material and tagged Excel, IBM Cognos TM1, MDX, Reporting. Bookmark the permalink. | Tagged Excel, IBM Cognos TM1, MDX, Reporting | 9 Comments

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

Messaging users of IBM Cognos TM1

Did you know that you can send messages to your users through TM1? You would be surprised how many people don’t realise that its possible – and easy!!! 1. Open TM1 Server Explorer (Perspectives) 2. Right click on your server and select “Server Manager”. From here you can actually do a few things like: Disconnecting Users and Shutting down (but not restarting) the server   3. Tick the box “Broadcast a Message” and … Continue Reading

This entry was posted in IBM Cognos TM1, TM1 10.1 and tagged Cognos, IBM Cognos, IBM Cognos TM1, TM1, TM1 Messaging. Bookmark the permalink. | Tagged Cognos, IBM Cognos, IBM Cognos TM1, TM1, TM1 Messaging | 1 Comment

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

Cognos Insight – Aligning using the Grid

Just found a cool little trick when organising widgets on a Cognos Insight Dashboard thanks to the team at IBM. You can hold shift while dragging or resizing widgets in Cognos Express to bring up the positioning grid. This makes alignment ridiculously easy. Cognos Insight – Olympic Medals – Australia – Swimming Click here for a 30-Day Free Trial of IBM Cognos Insight

This entry was posted in Cognos Insight, Training Material and tagged Cognos Insight, IBM Cognos Insight, Olympics Data, Tips & Tricks. Bookmark the permalink. | Tagged Cognos Insight, IBM Cognos Insight, Olympics Data, Tips & Tricks | Leave a comment

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 10.1 – IBM Cognos Insight Review Pt 2

In the first part of this review we had a look at the workings of IBM Cognos Insight and how it can effortlessly “munch down” a multitude of file formats an “crap out” a sexy looking dashboard. The scariest part of this is that it really works – and it looks great! The Pro’s Instant Data Visibility Brilliant for data reconciliation and quick ‘n’ easy to step through. I can see this … Continue Reading

This entry was posted in IBM Cognos TM1, TM1 10.1 and tagged Dashboard, IBM Cognos, IBM Cognos Insight. Bookmark the permalink. | Tagged Dashboard, IBM Cognos, IBM Cognos Insight | Leave a comment