Excel, TM1 and soccer

Subsets with commentary text

Jun. 10, 2015

Introduction

In TM1, you can create dynamic subsets. These are subsets that return 0 or more dimension elements based on an
MDX statement, a kind of definition of what elements to take from the dimension.
This is interesting for, for example, a public default subset or a public subset containing a dynamic list of all n-type elements (level 0).

{TM1Sort( TM1FilterByLevel( TM1SubsetAll( [Wine_Color] ), 0), Asc)}

The above MDX expression returns the list of all lowest-level accounts in the dimension Wine_Color.

As you can see, you can use Ascii character 10 to write to a new line in the MDX expression window.
The last parameter in the SubsetCreateByMDX function is used to avoid errors in case no elements would apply to the MDX definition.
Change the names accordingly to suit your TM1 model.
So good news, with this knowledge you can now automate the creation of subsets using custom Turbo Integrator coding !