MDX
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
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
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
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
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
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
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
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
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
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!