Using Custom MDX

<< Click to Display Table of Contents >>

Navigation:  User Guide > Using the Manager with TM1 > Managing Cube Views > Selecting Dimension Members (Subsets) > Setting Subset Properties >

Using Custom MDX

Custom MDX member selection method allows you to define your own MDX specific for this dimension within the view.

 

View Custom MDX

 

Best_200

BEST PRACTICE: Unless you are proficient at writing MDX statements, it is often helpful to enable recording in the TM1 Subset editor to build and test the MDX statement first. Once it has been validated, the generated MDX statement can be pasted in this input area.

 

Caution_200

CAUTION: If you use the expression recorder in TM1 Subset Editor to generate the MDX statement, it is important to replace the function TM1SubsetBasis() with TM1SubsetAll() or some other MDX expression. TM1SubsetBasis() function assumes you are starting with a subset already defined in TM1 to operate according to the settings of the saved subset (such as currently displayed alias name). TM1SubsetBasis() has no foundation with a custom MDX statement in TM1Connect, so it may not return the desired results.