Category Archives: MDX
Using Picklists in TM1 is a great way of ensuring data quality. We explain different types of pick lists, why you use & how to create each type of picklist so you can have in cell drop downs active inside 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.
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. So when using <set> in an MDX statement, usually you will refer to a subset of a dimension.