MDX Archives

Asymmetrical Views in Planning Analytics Workspace

Unlock the power of asymmetrical views in Planning Analytics Workspace (PAW) and transform your reporting! While traditional views offer symmetry, asymmetrical views allow you to tailor your data presentation, showcasing only the most relevant information for decision-making. Discover how to build these views using point-and-click methods or MDX code, and explore practical use cases like phased reporting and budget comparisons. Dive into this guide to elevate your analytics game and provide your users with precisely the data they need, enhancing clarity and insight in your planning processes. Don’t miss out on this opportunity to innovate your reporting!

Kathryn Dalton 8-January-2025

MDX

SIBLINGS MDX Function in TM1: Syntax, Use and Examples

Revolutionize your planning process with Siblings MDX. This powerful function simplifies data comparison, uncovers hidden insights, and drives smarter business decisions.
The Siblings MDX enabling efficient comparison of related data elements. Its ability to quickly identify and analyze sibling members significantly enhances data analysis capabilities.

Srinivas STP 21-August-2024

MDX

TOPCOUNT MDX Function in TM1: Syntax, Use and Examples

Have you ever wanted to identify the cream of the crop within your data in IBM Planning Analytics? Well, look no further than the TOPCOUNT MDX function! This powerful tool lets you sift through your multidimensional datasets and effortlessly extract the top performers based on your chosen criteria.

Srinivas STP 8-August-2024

MDX

BOTTOMCOUNT MDX Function in TM1: Syntax, Use and Examples

While the world often focuses on top performers, IBM Planning Analytics empowers you to delve deeper with the BOTTOMCOUNT MDX function. This unsung hero unlocks valuable insights by sifting through your data and identifying the bottom dwellers – the elements with the lowest values within a set.

Srinivas STP 15-July-2024

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 user-friendly and versatile. It allows you to retrieve the first element or a specified number of elements from any set. What’s even more exciting is that you can combine it with other MDX functions to gain deeper insights. Whether you’re an experienced MDX user or a beginner, the HEAD function is a game-changer that will leave you amazed. So go ahead, explore its potential through syntax, examples, and use cases—you won’t be disappointed!

Srinivas STP 28-June-2024

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 lets you get the last element or a specified number of elements from any set. What’s even cooler is that you can mix it with other MDX functions to get even more amazing insights. Whether you’re a seasoned MDX expert or a newbie, the TAIL function is a game-changer that will blow your mind. So why not give it a try and explore its potential through syntax, examples, and use cases? You won’t regret it!

Srinivas STP 28-June-2024

Dynamic Sets for Current Period for use in Planning Analytics

Excel Reports

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 Analytics Workspace and Excel.

Gautam Narula 6-June-2024

MDX

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

kav1908 2-March-2024

Admin Best Practices

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 screenshots to fix poor performing MDX based subsets.

Gautam Narula 1-March-2024

Dimensions

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

kav1908 1-March-2024

Dimensions

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.

johnv 4-March-2022

Dimensions

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.

johnv 16-November-2020

Attributes

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 Types of Picklists, How They Can Help You, and How to Create Them. Enjoy In-Cell Drop-Downs in TM1 with Ease!

johnv 4-July-2024

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.

johnv 3-December-2015

Elements

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

johnv 5-July-2024

Dimensions

MDX in TM1 – an Introduction

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

johnv 19-September-2014

Dimensions

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 this task and generate many MDX statements? TI process in conjunction

Ivan.Kulman 1-March-2024

MDX

MDX Primer

Here’s a link to our preferred MDX source on the web BI Hints from Win Gielis. It si an awesome source for all things MDX in TM1. On it you

Wim Gielis 28-June-2024

MDX

Asymmetrical Views in Planning Analytics Workspace

SIBLINGS MDX Function in TM1: Syntax, Use and Examples

TOPCOUNT MDX Function in TM1: Syntax, Use and Examples

BOTTOMCOUNT MDX Function in TM1: Syntax, Use and Examples

HEAD MDX Function in TM1: Syntax, Use and Examples

TAIL MDX Function in TM1: Syntax, Use and Examples

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

Filter MDX Function in Planning Analytics

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

Descendants MDX Function in Planning Analytics

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

Children-MDX for Next Level Only of TM1 Element

Picklists in Planning Analytics: How to Create and Use Them

Creating Dynamic Subsets in TM1

What is a Set in a TM1 MDX Expression

MDX in TM1 – an Introduction

TM1: Top N Elements from a Tuple

MDX Primer

Contact

Company

Resources

MDX

Contact

Company

Resources

Log In