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.

Virtual Dimensions in TM1 and Planning Analytics Explained

Posted on Nov 1, 2018 by John

What are Virtual Dimensions? Virtual dimensions in TM1/Planning Analytics are an excellent way of adding new analysis capability to a TM1 cube without changing the underlying structure of the cube,...

Create a TM1 Send Sheet in Excel

Posted on Oct 15, 2018 by John

Sometimes we have data that is created in Excel and we need to load it into TM1 directly from the Excel sheet. This blog post details how to create a...

Weights in TM1 – What They Are and How to Use Them

Posted on Oct 8, 2018 by John

What are Weights in TM1? Weights in TM1 are used to change the way an element in a dimension is added up into a parent element. For example, if you...

Connecting Planning Analytics for Excel (PAX) to TM1

Posted on Oct 5, 2018 by John

Here we detail how to create a new connection in Planning Analytics for Excel (PAX) to a TM1 model or server. What is Planning Analytics for Excel (PAX)? Planning Analytics...

Persistent Feeders in TM1 – Explanation and Implementation

Posted on Sep 22, 2018 by John

Do you have a large TM1 model that takes forever to load when it is restarted? Do you have complex feeders or large feeder files in your model? If you...

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...

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...

Need help with TM1?
We're here for you



Keen to chat? Book a discovery call!