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 Pick List – How to Create and Use Picklists in TM1

Posted on Oct 27, 2016 by John

Picklists in TM1 are a great way for you to ensure that users only “enter” (or in this case select) a value from a standard dropdown list of options. For…

Creating Dynamic Subsets in TM1

Posted on Dec 3, 2015 by John

Have you ever needed to have a TM1 subset that automatically includes all elements? What, I hear you say, doesn’t that always occur? Well no.  You can have static subsets…

What is a Set in a TM1 MDX Expression

Posted on Sep 19, 2014 by John

A <set> in an MDX expression in TM1 refers to a group of elements.  Usually in TM1, this would be a subset in a dimension, although note that not all subsets…

MDX in TM1 – a Basic Introduction

Posted on Sep 19, 2014 by John

MDX in TM1 leverages of the standard MDX language (note leverages off, not uses). It is an industry standard query language for multi dimensional analysis. TM1 does not support the entire…

Need help with TM1?
We're here for you



Keen to chat? Book a discovery call!