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 just structured lists of elements (or sometimes known as members). So a list of product, months, customers, measures, years, accounts, cost centres, WBS codes, versions, […]
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.
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 user is unable to click anywhere, until TM1 displays all the elements under the consolidated element in the property window. How to avoid Architect Hanging […]
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.
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 are created by MDX. Therefore, when using <set> in an MDX statement, usually you will refer to a subset of a dimension. Example of a […]