Category Archives: Training Material

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 remodelled with added analytics

I’m pleased to announce that TM1 Tutorials.com has had a complete rebuild and today we have launched the new site, just in time for IBM Information On Demand (IOD). Please head on over to the new and improved TM1 Tutorials.com and see for yourself what all the fuss is about! You can also track our progress at IOD by following @TM1Tutorials on twitter. The new TM1 Tutorials website is now … Continue Reading

This entry was posted in Cognos BI, Cognos Disclosure Management, Cognos Express, Cognos Insight, IBM Cognos TM1, SPSS, Training Material and tagged IBM Cognos BI, IBM Cognos Disclosure Management, IBM Cognos TM1, IBM SPSS, IBMIOD, Information on Demand. Bookmark the permalink. | Tagged IBM Cognos BI, IBM Cognos Disclosure Management, IBM Cognos TM1, IBM SPSS, IBMIOD, Information on Demand | Leave a comment

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

TM1 10.2 – Introducing CAFE

In this article we are going to introduce to you the new Excel Client for TM1 called Cognos Analysis for Microsoft Excel (CAFÉ). For those of you that have been using IBM Cognos BI you might think that this is not new and that you might have been using it for years. But it is new for TM1 users because IBM Cognos Analysis for Microsoft Excel is now integrated with … Continue Reading

This entry was posted in TM1 10.2, Training Material and tagged Café, Cognos Cafe, Excel Addin, IBM Cognos TM1. Bookmark the permalink. | Tagged Café, Cognos Cafe, Excel Addin, IBM Cognos TM1 | 8 Comments

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

TM1 10.2 – Feature Change: Cell Security Cubes

Model security can now be applied and amended on an application using Performance Modeller, this includes security for cells, cubes, dimensions, processes and chores.  A few key changes to note: Changing security on applications will take effect immediately Security applied to the applications can be deleted with ease in the model Cell security on a cube can be applied to selection of dimensions, instead of all dimensions in the cube … Continue Reading

This entry was posted in IBM Cognos TM1, Performance Modeler, TM1 10.2, Training Material and tagged Business Analytics, Cell Security, Cube Security, IBM Cognos TM1, Model Security, Process Security, Security, TM1 10.2. Bookmark the permalink. | Tagged Business Analytics, Cell Security, Cube Security, IBM Cognos TM1, Model Security, Process Security, Security, TM1 10.2 | Leave a comment

TM1 10.2 – New Feature: In-Cube Calculations

We are excited about the new TM1 release, 10.2.  It has a lots of new features that will make life easier for TM1 modellers.  One of the key new features is doing in-cube calculations on Performance Modeller.  Here are a few things that you may find interesting and/or enjoy having.

This entry was posted in IBM Cognos TM1, Performance Modeler, TM1 10.2, Training Material and tagged Business Analytics, Business Logic, IBM Cognos TM1, In-Cube Calculations, TM1 10.2. Bookmark the permalink. | Tagged Business Analytics, Business Logic, IBM Cognos TM1, In-Cube Calculations, TM1 10.2 | 3 Comments

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 Overview

Heres a visual guide to the new multithreading feature in IBM Cognos TM1 10.2.   In the given example above the calculation stage of answering a request from a user takes up 99% most of the processing time for the request. So within TM1 10.2 the request calculation is split into chunks which are then delegated to separate CPU Cores. The enhanced performance can be calculated as:   Where: ‘e’ … Continue Reading

This entry was posted in IBM Cognos TM1, TM1 10.2, Training Material and tagged IBM Cognos TM1, Multithreading. Bookmark the permalink. | Tagged IBM Cognos TM1, Multithreading | Leave a comment

Adding a dimension to an existing cube

Business requirements for reporting and planning are likely to change over time, and in some cases, changes can happen quite regularly and rapidly.  So, the cube structures that was implemented initially will likely need changing, such as adding a new dimension to existing cubes for enhanced analysis and/or planning. In the past, adding a dimension to an existing cube directly would not be possible.  Unless creating a new cube with … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, Performance Modeler, Training Material and tagged Adding Dimensions to an existing cube, IBM Cognos Express, IBM Cognos TM1, Modelling, Performance Modeler. Bookmark the permalink. | Tagged Adding Dimensions to an existing cube, IBM Cognos Express, IBM Cognos TM1, Modelling, Performance Modeler | Leave a comment