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.

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 from your data. Here we explore what it really is and how it can be used.

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

Checking if an Attribute Exists (essentially an “AttributeExists” Function)

Posted on Nov 27, 2017 by John

Have you ever looked for a TM1 function that checks if an attribute exists, something like say “AttributeExists” or “AttrExists”. Well there isn’t one. But, don’t dispair, here is a…

Date Function in TM1: Syntax and Use

Posted on Oct 31, 2017 by John

The DATE function in TM1 converts a serial date to a text version of the date in either YYYY-MM-DD or YY-MM-DD format. For example, let’s say you have a date…

TM1 and Excel Dates No Longer in Conflict!

Posted on Oct 24, 2017 by John

TM1 dates and Excel dates have been in conflict since the birth of TM1. TM1 used a serial number of 1 for its start date of 1-Jan-1960, while in Excel…

How to Create a List Report using a TM1 Active Form

Posted on Oct 16, 2017 by John

Ever wondered how to create an Excel list report over a TM1 cube that dynamically expands based on filters so you always get all relevant rows? Well you can, by…

Need help with TM1?
We're here for you



Keen to chat? Book a discovery call!