TM1 Forum

I have the below mdx to select the 3 items in level 3

{TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[Items].[All Teams].[50].[50 - 5].[50 - 5 - 406],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 407],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 409]}, ALL, RECURSIVE )}, 3)}


now i need modify the mdx to choose 2 items from level 3 and one item from level 4


50-5-406, 50-5-407, 50-5-409-010

In the above mdx i filter by level 3 , since all a re level 3 , now i have level 3 and level 4 how do i change the mdx .

UNION should work

Analytics123 wrote: ↑Wed Oct 18, 2017 3:22 pm I have the below mdx to select the 3 items in level 3

{TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[Items].[All Teams].[50].[50 - 5].[50 - 5 - 406],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 407],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 409]}, ALL, RECURSIVE )}, 3)}

Why do you include the full path to the elements in the MDX code ? Elements in a dimension are unique, no ?

{TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[Items].[All Teams].[50].[50 - 5].[50 - 5 - 406],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 407]}, ALL, RECURSIVE )}, 3)} + {TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[Items].[All Teams].[50].[50 - 5].[50 - 5 - 409]}, ALL, RECURSIVE )}, 4)}