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 10.2 – Introducing CAFE

Introduction to TM1 Cafe – the new Excel based front end for TM1. How to use it with Flex Views and Exploration Mode.

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 Modeller, 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

TM1 model security can be applied and amended on an application using Performance Modeller, this includes security for cells, cubes, dimensions, processes and chores. Here’s how.

This entry was posted in IBM Cognos TM1, Performance Modeller, 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 Modeller, 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 Modeller, 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’ is enhancement. … 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 | 1 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 Modeller, 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

Finding the Rules Editor in Cognos Insight

I was tasked to draft up something on Cognos Insight.  Without going through the Cognos Insight user guide, I have got stuck when trying to link data between cubes.  “How I do edit rules in Insight?”, I asked. Until I have got a reply from a colleague, “Look for the widget toolbars!”. Have you ever been wondering why there are so very few menu options on the main toolbar in … Continue Reading

This entry was posted in Cognos Insight, Training Material and tagged Cube Rules, IBM Cognos Insight, Modeling, Rules Editor. Bookmark the permalink. | Tagged Cube Rules, IBM Cognos Insight, Modeling, Rules Editor | Leave a comment