TM1 Forum

When writing a view MDX statement inclusive of a subset, what is the preferred syntax to use?

Is it:

(A) [Dimension].[Hierarchy].[Set]
-or-
(B) TM1SubsetToSet([Dimension].[Hierarchy], 'Subset')?

Option (A) is more succinct, but TM1 tends to "auto generate" (B), hence my question.

99% of the time they will be exactly the same results.
However, if you had an element and subset with the same name - it would return the element instead of the subset... so using SubsetToSet makes sure that it returns the subset.

It’s probably good practice to be as explicit as possible of what you want as you may not have any elements and subsets with the same names now but in the future things might change and you may overlook the impact of it in this case.