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.

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

DType Function in TM1: Syntax and Use

Posted on Apr 13, 2018 by John

One of the team were just writing a TI to load a text file into TM1. It was all working swimmingly until he tried to load a string (a 3...

How Data Visualisation Can Revolutionise Your Business

Posted on Apr 9, 2018 by John Vaughan

What is data visualisation? We like to think of it as “a picture that explains a million numbers”. It is a vital business tool you can use to extract value...

How to Change TM1 to use Cognos Security (CAM)

Posted on Apr 6, 2018 by John

Configuring TM1 to use Cognos security allows you to use your corporate directory server (like Microsoft’s Active Directory) and move the addition of users and placement of users into groups...

Enabling TM1 Rules via a Control Cube

Posted on Mar 20, 2018 by John

Today we were looking at how we could optimise a client’s rules to improve performance. The first couple of rows of rules were STET rules. In other words, rules that turn on...

Cascading Element Level Security in TM1

Posted on Feb 17, 2018 by John

We are doing a large project at a multi business unit company. The client is very security conscious and wants to ensure t members of a business unit can only...

MONTH Function in TM1: Syntax and Use

Posted on Dec 5, 2017 by John

The Month function in TM1 extracts a numeric version of month from a text string that represents a date, where the date has been presented in either YYYY-MM-DD or YY-MM-DD format....

Need help with TM1?
We're here for you



Need help? Get in touch!