MDX in Planning Analytics

MDX, or Multi Dimensional Expressions, are at the core of Planning Analytics for Excel, Planning Analytics Workspace and the Set Editor right throughout TM1. This series covers the basics through to more complex uses of MDX in Planning Analytics.

01.

Dimensions | MDX

MDX in TM1 – an Introduction

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

Read

MDX Primer Tutorial

Hi Here’s a link to my preferred MDX source on the web: www.bihints.com Wim...

Read

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

John Vaughan

1 min read

Read

04.

MDX

Filter MDX Function in Planning Analytics

Definition The TM1 MDX function FILTER in IBM Planning Analytics is utilised to selectively...

Read

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

Read

Descendants MDX Function in Planning Analytics

Definition The ‘Descendants’ MDX function in TM1/Planning Analytics is used to generate...

Read

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

John Vaughan

2 min read

Read

08.

Dynamic Reports | Excel Reports | Reporting | Reporting Case Studies

How To Create the Top 10 Basic Reports Using MDX Expression

Here is a fully worked example of using MDX in a TM1 Dynamic Report to create a Top 10 style...

John Vaughan

3 min read

Read

09.

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

Do you have slow reports with large subsets using MDX? Here's a best practice guide with...

John Vaughan

4 min read

Read