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.

Filter MDX Function in Planning Analytics

Posted on Sep 6, 2023 by Kleber

Definition The TM1 MDX function FILTER in IBM Planning Analytics is utilised to selectively retrieve data from multidimensional cubes based on specified criteria. In conjunction with other MDX functions like…

Slow MDX Subsets? Best Practice Guide to Maintain Sets in TM1

Posted on Aug 11, 2023 by Gautam Narula

Having MDX based dynamic subsets in TM1 is a fantastic way to ensure that reports, forms and processes that use those subsets contain all required elements. But there is an…

Descendants MDX Function in Planning Analytics

Posted on Aug 7, 2023 by Kleber

Definition The ‘Descendants’ MDX function in TM1/Planning Analytics is used to generate a set containing all descendant members (i.e. children, grand children, great grand children etc) below a specified member…

N Level-MDX for Leaf Level Elements from an Ancestor in TM1

Posted on Mar 4, 2022 by John

Today I was looking for the MDX to get the leaf level (or N level or Base Level) elements from a dimension after supplying the name of an element further…

Children-MDX for Next Level Only of TM1 Element

Posted on Nov 17, 2020 by John

Have you ever wondered how to generate a dynamic subset using MDX that contains JUST the immediate children of a parent from a TM1 dimension? This is just so easy,…

Picklists in TM1: How to Create and Use Them

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 from a validated list) a value from a standard dropdown…

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



Popular Articles

Keen to chat? Book a discovery call!