Category Archives: TM1 10.1

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

TM1 Tutorials Consultation – Ben Hill

When I started this site as a freelancer I was happy to cater to the need for non biased technical resources which solve real world problems. Back in Jul 2012 I joined InfoCube Consulting (Australia) as Director and Principal Consultant with the intention of creating something bigger than myself. I’m happy to say that now we are a team of over 10 expert consultants and we are growing quickly. So… … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 10.2, Training Material and tagged Consulting, IBM Cognos TM1, Training. Bookmark the permalink. | Tagged Consulting, IBM Cognos TM1, Training | 1 Comment

Sydney Networking – TM1 10.2 Upgrade Special.

October 18th – Sydney TM1 Networking. TM1 Catchup – 10.2 Upgrade Special. We have arranged a special TM1 catch up dedicated to the 10.2 update. We believe this is the biggest update to the platform since Applix acquired TM1 in 1996. This is an opportunity to discuss what is new, what we like, what we don’t like and of course how we can make the best of the update over … Continue Reading

This entry was posted in Events & Networking, IBM Cognos TM1, TM1 10.1, TM1 10.2 and tagged Event, IBM Cognos TM1, TM1 Drinks. Bookmark the permalink. | Tagged Event, IBM Cognos TM1, TM1 Drinks | Leave a comment

Generating a Time Dimension in Performance Modeller

Almost all TM1/Cognos Express applications will require a time dimension, and creating a time dimension has never been easier, with Time Dimension Tool provided in performance modeller. Here are a few simple steps:

This entry was posted in Cognos Express, IBM Cognos TM1, Performance Modeler, TM1 10.1, Training Material and tagged Dimension, Dimension Editor, Hierarchies, IBM Cognos Express, IBM Cognos TM1, Performance Modeler. Bookmark the permalink. | Tagged Dimension, Dimension Editor, Hierarchies, IBM Cognos Express, IBM Cognos TM1, Performance Modeler | 1 Comment

Linking Cubes with Performance Modeler

Performance modeller makes moving/linking data between cubes (and within cube) with ease, and it also makes it easier to track and update as each link is saved separately. For those who have experience with Cognos Enterprise Planning, this will make you feel right at home. Here is a simple example on how to create a link: Start up performance modeller, log onto IBM TM1/CX Planner Applications (http://<server host>:9300/pmpsvc) and click … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, Performance Modeler, TM1 10.1, Training Material and tagged D-Link, IBM Cognos Express, IBM Cognos TM1, Performance Modeler. Bookmark the permalink. | Tagged D-Link, IBM Cognos Express, IBM Cognos TM1, Performance Modeler | Leave a comment

TM1 10.2 – Multithreading Performance Tests

Many promising claims about performance improvements were made for TM1 10.2, most of which are related to the new multi-threading feature that allows to utilise as many threads as the server has. The pre TM1 10.2 situation was pretty uninspiring as TM1 server could use only one thread per request, which seems quite out-dated in the era when even mobile phones have 4 cores! That said, some initial steps like … Continue Reading

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

CX/TM1 Monitoring on the App Store – Spark Mobile

Spark Mobile is now on the iTunes App Store. Thanks to all the beta testers. You can access and download the free iPhone / iPad App here. This brings the insights the Spark Cloud has to offer, direct to your mobile device! Notifications about significant events can now be pushed directly to your mobile device and at a touch you can now see Server Configuration, Logs and TM1Top Activity. We hope you … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, InfoCube Spark, TM1 10.1 and tagged Cloud, Congos TM1, IBM Cognos Express, IBM Cognos TM1, InfoCube Spark, Monitor. Bookmark the permalink. | Tagged Cloud, Congos TM1, IBM Cognos Express, IBM Cognos TM1, InfoCube Spark, Monitor | 2 Comments

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

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