TM1 Forum

After more research and assistance from a colleague I have the answer: {HIERARCHIZE( {EXCEPT({DESCENDANTS([DIM].[Parent])},{TM1FILTERBYLEVEL({DESCENDANTS([DIM].[Parent])},0)})} + {TM1FILTERBYLEVEL({FILTER({FILTER({DESCENDANTS([DIM].[Parent])},[DIM].[Attribute1]='XXXX')},[DIM].[Attribute2]='XXXX')},0...

Hello All I want to create an MDX driven report containing all parents of a set of n-level elements that are filtered by attributes. HIERARCHIZE(FILTER ( GENERATE(Filter( TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {[DIM].[PARENT]}, ALL, RECURSIVE )}, 0), [DIM].[ATTRIBUTE] = "XXXX"),[DIM].Curre...