MDX

Filtering Data

Filter MDX Function in Planning Analytics

Definition The TM1 MDX function FILTER in IBM Planning Analytics is utilised to selectively retrieve data from multidimensional…

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…

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…

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

Use MDX to return JUST the children of a parent element in TM1. Simple explanation with worked example. THis MDX can then be used to export just those elements.

Children-MDX for Next Level Only of TM1 Element

Use MDX to return JUST the children of a parent element in TM1. Simple explanation with worked example. THis MDX can then be used to export just those elements.

Picklists in TM1

Picklists in TM1: How to Create and Use Them

Using Picklists in TM1 is a great way of ensuring data quality. We explain different types of pick lists, why you use & how to create each type of picklist so you can have in cell drop downs active inside TM1.

Creating Dynamic Subsets in TM1

Dynamic Subsets in TM1 and Planning Analytics allow you to create sets of elements that always contain all relevant elements. For example, all children of a parent, or all level 0 elements. They are extremely useful in Dynamic Reports as with them you can be sure that all elements are displayed.

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…

MDX in TM1 – an Introduction

Here’s how to create dynamic subsets in TM1 by using recorded MDX, with an explanation of MDX.

TM1: Top N Elements from a Tuple

Writing MDX statements is a very helpful skill for a TM1 person, but what if you need to…

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement