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.
How to Import the New Visualisation Charts into IBM Cognos BI
The new visualisation engine from IBM (RAVE) looks amazing and within this article we will show you how to access the charts and use them within report studio. Note that they can be used in traditional reporting and active reports. First step is to go to Analytics Zone. This is an IBM site where you can […]
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 […]
IBM Cognos Express 10.2.1 What's new
IBM Cognos Express 10.2.1 is out. Here is a list of what is new: 1. The first notable change is that Cognos Express is on the same version with Cognos Enterprise. This means that integrated under the hood you will find: Cognos BI version 10.2.1.1, TM1 version 10.2 and Cognos insight 10.2.1. This also means […]
TM1 Consultation – Ben Hill
When I started this site’s predecessor, TM1Tutorials.com, 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 as Director and Principal Consultant with the intention of creating something bigger than myself. I’m happy to say that now […]
Triggering TI Processes from TM1 Application Workflow
How to trigger a TM1 Turbo Integrator process after a workflow state has been changed in a TM1 Contributor Application.
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:
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 […]
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 […]
Testing Turbo Integrator Code
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 […]
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 […]
TM1 at month-end
IBM Cognos TM1 is … what it has been developed to do within your environment. Unfortunately that means most companies aren’t getting the most out of their investment as it has been sold to them as a single point solution, solving a single point problem – So I thought that over the next for months […]
Monte Carlo simulation with TM1
A bit about Vangelis: Hi, I am Vangelis, I am from Greece and now I live in Sydney Australia. Currently, I’m working as a consultant at Infocube Consulting. I have expertise in IBM Cognos products, BI and TM1 and also in mathematics and statistics. My academic background consists of a BSc in Mathematics, MSc in […]
Woohoo! TM1 Tutes has cracked 100,000 visits!
This is just a shout out to all the administrators, support teams and developers who have browsed or subscribed to the TM1 Tutorials blog over the last two years. Thanks, your the best and we are so pleased to have the opportunity to share our time tested tips and tricks with you all If you are […]
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 […]
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 […]
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 […]
Free Trial of Cognos Insight – Big Data Analytics
A free trial of Cognos Insight is available for download on Analytics Zone – Download Now. What is Analytics Zone? Analytics Zone is a community portal focusing on Big Data Analytics. Its a great place for connecting with other analysts and data scientists, downloading modelling (Not “Project Runway”) resources, tutorials and catching up with the latest Big Data […]
TM1 Contributor – Single Security Hierarchy
Currently on-site at client installing TM1 Cognos Express. The client wishes to use the contributor application to utilize workflow in the forecast. Doing so can creates a number of limitations, namely security and secondly cube design. Within TM1 Contributor/Cognos Express Planner you apply security based on a single dimension hierarchy for the application you have […]
Rolling Forecasts in IBM Cognos TM1
Recently, a client has asked to implement a rolling forecast model to move towards a more dynamic way of forecasting. With this as periods move forward so does your forecast. In this way you are always forecasting 12 / 18 months out in to the future. What is a Rolling Forecast With a rolling forecast […]