Category Archives: Training Material
This blog shows the steps needed to establish an ODBO connection in order to transfer data between 2 cubes in different server instances.
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
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
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
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:
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
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.
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
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