SubsetCreateByMDX

We have discussed building subsets using the SubsetCreate and SubsetElementInsert functions earlier in this chapter. Another method that can be used to create a subset is by using the SubsetCreateByMDX function. This function creates a subset based upon a properly formatted MDX expression.

MDX is a powerful way to create complicated lists. However, TM1 only supports a small number of MDX functions (not the complete MDX list). You will find that different versions of TM1 support different functions. Before using MDX in TM1 you need to check under Reference Material | MDX Function Support in the main help file supplied with the version of TM1 you are using. If TM1 encounters an unsupported MDX function, you will receive the message Failed to compile expression.