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.
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.
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.
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!
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!
Discover a clever method to dynamically update period selectors to the current month in Planning Analytics Workspace and Excel.
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
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
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
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.
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
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
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.
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
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.
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.
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.
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.
DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in TM1 in a TI process.
The AttrClear or ClearAttr function doesn’t exist in TM1. Here is an easy method to replicate what functions like these would do, with a downloadable example
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
