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 ) }

tm1_mdx_filter_by_substring

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

Recent Posts

Recent Comments

Meta

Written by:

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *