TM1FILTERBYPATTERN( <set>, <pattern_str>, [<attribute>] )

This TM1 -specific MDX function returns all the members in a specified <set> with names matching the pattern <pattern_str>. You can also use an optional third parameter, <attribute>, to search for attribute values.


The syntax of <pattern_str> is the same used for the Select By Regular Expression option on the Set Editor.


TM1FILTERBYPATTERN(TM1FILTERBYLEVEL(TM1SUBSETALL([Income Statement Account].[Income Statement Account]) , 0),"0099*","MEMBER_NAME")

This example returns all MEMBER_NAME attributes for 0-level members from the Income Statement Account dimension that match the pattern string 0099*.