TM1 MDX FILTER BY SUBSTRING

The next technique allows to filter elements by attribute / name substring:

{ FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [MyDim] )}, 0)}, INSTR([MyDim].[MyAlias], "SubString" ) > 0 ) }

* There is also TM1FILTERBYPATTERN function but it’s limited to filtering by name only and doesn’t have “negation”