We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

The BI and Data Visualisation Mistake Your Organisation Probably Makes

Posted on Sep 17, 2018 by John Vaughan

Learn the biggest data visualisation mistake organisations make, which does more harm than good and how you can avoid it!

IBM Software on Virtual Servers Could Expose You Millions (Literally)!

Posted on Sep 6, 2018 by John Vaughan

IBM software installed on virtual servers could potentially expose your organisation to a claim from IBM for millions. The risk is real. We’ve seen the claims. Here is what you can do now to avoid this significant and job threatening exposure.

Days in Month – How to Easily Calculate in a TM1 Rule

Posted on Aug 25, 2018 by John

Calculating the number of days in a month is used for a number of financial calculations, such as inventory days and debtor days. Have you ever wondered though how to…

Choose Your Favourite ExploringTM1 T-Shirt

Posted on Jul 31, 2018 by John

To celebrate almost 100,000 visitors to and almost half a million page views, we have decided to create an t-shirt to give away to the ExploringTM1 community and…

DimensionElementDelete Function TM1: Syntax and Use

Posted on Jun 25, 2018 by John

Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete permanently deletes the element from the TM1 dimension and all associated data from any…

CubeSetLogChanges TM1 function: Syntax and Example

Posted on Jun 3, 2018 by John

When we run a Turbo Integrator process in TM1, the Transaction Log will normally have a record written for each data change. To speed up the TI, we can turn…

CreateHierarchyByAttribute Function in TM1: Syntax and Use

Posted on May 31, 2018 by Boon Ong

We have recently done a project where we needed to create an excel report showing attributes from the same dimension as the rows and columns in a report. Traditionally in…

Who Changed that TM1 Data? Using the TM1 Transaction Log

Posted on May 28, 2018 by John

Have you ever had an inexplicable change to TM1 data? you know, when a user comes to you and says, John (in my case), the data in TM1 has changed…

Over Feeding in TM1 – What is it and How to Avoid it

Posted on May 23, 2018 by Andrew Walker

Do you have a large TM1 model that is consuming excess memory? Is performance suffering because of the size of the model? If so, you might have a situation where…

How to Take a Snapshot in Planning Analytics for Excel

Posted on May 21, 2018 by John

Planning Analytics for Excel (or PAX) provides an Excel based interface to TM1 data. It provides a highly flexible environment for users to create their own reports from TM1 data…

Need help with TM1?
We're here for you



Keen to chat? Book a discovery call!