TM1 Forum

ExApplix wrote: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

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