Exploring TM1 - a Chartertech Company
Search
Close this search box.

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

Cognos Insight – Aligning using the Grid

Just found a cool little trick when organising widgets on a Cognos Insight Dashboard thanks to the team at IBM. You can hold shift while dragging or resizing widgets in Cognos Express to bring up the positioning grid. This makes alignment ridiculously easy. Cognos Insight – Olympic Medals – Australia – Swimming Click here for a 30-Day Free Trial […]

Automating Data Transfers between TM1 Servers

Replicating a Cube from a one TM1 Server into another has never been easier. Follow the steps below to copy a cube from one server to another (this includes synchronising TM1 Dimensions). This process uses the ODBO Provider for TM1 and generated MDX. I was going to show how to create an MDX Query for the desired […]

TM1 10.1 – IBM Cognos Insight Review Pt 2

In the first part of this review we had a look at the workings of IBM Cognos Insight and how it can effortlessly “munch down” a multitude of file formats an “crap out” a sexy looking dashboard. The scariest part of this is that it really works – and it looks great! The Pro’s Instant […]

The [Black Box] Killer

In the past when corporate finance came across a “Big” Data problem, very often the solution was created by a member of the team particularly good with VBA and access databases. They would often slave away for days on end creating the solution to this particular problem. This solution was usually needed due to row […]

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 […]

InfoCube and Daptech to Merge

InfoCube, a Sydney-based management accounting and business analytics specialist, and enterprise planning software experts Daptech will merge their businesses to create InfoCube Consulting (Australia) Pty Ltd. Commencing trading on July 9, the new entity will continue to provide clients such as Woolworths, Goodman Fielder, News Limited, Schneider and Hunter Douglas with superior Cognos service and […]

IBM Cognos TM1 10.1 – The Installation

I’m going to talk through the installation of TM1 10.1. Prerequisites: Microsoft Visual C++ 2005 SP1 Redistributable Package Microsoft .NET 3.5 SP1 Framework Microsoft Chart Controls for Microsoft .NET Framework 3.5. Microsoft Excel Getting Started: To kick of you’ll need either an installation CD or Archive. When downloading directly from IBM’s website you’ll be using […]

Log In