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.

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

Here’s a link to our preferred MDX source on the web BI Hints from Win Gielis. It si an...

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

Read

Dimensions | Dynamic Reports | MDX | Reporting

Creating Dynamic Subsets in TM1

Dynamic Subsets in TM1 and Planning Analytics allow you to create sets of elements that always...

Read

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

Read

Dynamic Sets for Current Period for use in Planning Analytics

Excel Reports | MDX | Planning Analytics Workspace | Sets

Automatically Display Current Period in Planning Analytics Workspace and Excel with Clever MDX

Discover a clever method to dynamically update period selectors to the current month in Planning...

Read

Admin Best Practices | Administration | Dimension Best Practices | Dimensions | MDX | Sets

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

Read

Picklists in TM1

Attributes | MDX | Picklists | Security

Picklists in Planning Analytics: How to Create and Use Them

Discover the Benefits of Using Picklists in TM1 for High-Quality Data! Learn about the Various...

Read

Dimensions | Dynamic Reports | Elements | MDX | Reporting

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

Read

Filtering Data

Filter MDX Function in Planning Analytics

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

Read

Dimensions | MDX

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

Dimensions | MDX

Descendants MDX Function in Planning Analytics

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

Read

MDX Leaves

Dimensions | MDX

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

Read

TM1 Head MDX

HEAD MDX Function in TM1: Syntax, Use and Examples

Unleash the power of the HEAD MDX function in IBM Planning Analytics! This function is both...

Read

TM1 TAIL MDX

TAIL MDX Function in TM1: Syntax, Use and Examples

Discover the awesomeness of the TAIL MDX function for IBM Planning Analytics! It's easy to use and...

Read