Search
Close this search box.

MDX

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!

Read More »
MDX
Srinivas STP

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.

Read More »
MDX
Srinivas STP

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.

Read More »
MDX
Srinivas STP

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.

Read More »
TM1 Head MDX
MDX
Srinivas STP

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!

Read More »
TM1 TAIL MDX
MDX
Srinivas STP

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!

Read More »

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.

Read More »
Dimensions
Ivan.Kulman

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

Read More »
MDX
Wim Gielis

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

Read More »

Log In