MDX Filter by Level (in SubsetCreateByMDX)

[ExApplix]

In TI we can create Subsets based on the FilterByLevel e.g

Code: Select all

SubsetCreateByMDX('MySubsetName', '{TM1FILTERBYLEVEL( {TM1SUBSETALL([MyDimensionName] )}, 0)}');

will select the Zero Level elements.

but I want to select the Level Zero and the Level 1 elements at the same time. Please tell me how can I do it using the above MDX

Please help!!!!

[Alan Kirk]

In TI we can create Subsets based on the FilterByLevel e.g

Code: Select all

SubsetCreateByMDX('MySubsetName', '{TM1FILTERBYLEVEL( {TM1SUBSETALL([MyDimensionName] )}, 0)}');

will select the Zero Level elements.

but I want to select the Level Zero and the Level 1 elements at the same time. Please tell me how can I do it using the above MDX

Code: Select all

SubsetCreatebyMDX('SubsetName', '{TM1FILTERBYLEVEL( {TM1SUBSETALL( [DimName] )}, 0,1)}' );