Dimensions 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

Dimensions

How to Create a User Defined Consolidation in TM1 Architect & Perspectives

Sometimes we want to create a rollup of elements from a dimension that does not exist in the dimension structure itself. We have a choice. We can either go back

johnv 1-March-2024

Dimension Best Practices

Dimensions in TM1

Dimensions are one of the fundamental building blocks in TM1. We put dimensions together to create cubes and then cubes to hold data. What are Dimensions? Dimensions in TM1 are

johnv 1-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

Stop Architect Hanging when Clicking Consolidated Element

There are times user face issues trying to navigate in the dimension (subset editor) with thousands of elements, and accidentally click on the consolidated element. TM1 Architect hangs and the

Gautam Narula 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

DimensionDestroy: How to Delete a Dimension in TM1

Sometimes we want to just delete a dimension from TM1. We get lots of failed searches on our site for DimensionDelete – but unfortunately that doesn’t exist. IBM, in their

johnv 3-September-2021

Dimensions

Cascading Picklists in TM1 – How to Create in 4 Steps

Cascading Picklists in TM1 are a great way to limit long lists from being displayed to users for selection. Here we explain exactly how to create them.

johnv 24-April-2024

DimensionElementPrincipalName Rules Excel

Elements

How to Get an Element ID from an Alias in a TM1 Rule or Excel Report

Need to get a primary element name from an alias in a TM1 Excel report or TM1 Rule? Simple solution for deriving an element principal name in Rules or Excel.

johnv 4-June-2024

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

Display TM1 Attributes in Cognos Analytics Crosstab

Here is how to create a Cognos Analytics Crosstab and use the contents of a TM1 Attribute for the rows, rather than the element IDs from TM1.

johnv 1-March-2024

DimensionElementPrincipalName, How to Use and Syntax

DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in TM1 in a TI process.

johnv 19-September-2019

Dimensions

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

How to Create a User Defined Consolidation in TM1 Architect & Perspectives

Dimensions in TM1

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

Descendants MDX Function in Planning Analytics

Stop Architect Hanging when Clicking Consolidated Element

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

DimensionDestroy: How to Delete a Dimension in TM1

Cascading Picklists in TM1 – How to Create in 4 Steps

How to Get an Element ID from an Alias in a TM1 Rule or Excel Report

Children-MDX for Next Level Only of TM1 Element

Display TM1 Attributes in Cognos Analytics Crosstab

DimensionElementPrincipalName, How to Use and Syntax

Contact

Company

Resources

Dimensions

Contact

Company

Resources

Log In