Posts
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
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)!
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
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
To celebrate almost 100,000 visitors to ExploringTM1.com and almost half a million page views, we have decided to create an ExploringTM1.com t-shirt to give away to the ExploringTM1 community and…
DimensionElementDelete Function TM1: Syntax and Use
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
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
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
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
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
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!
