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.
Syntax
The syntax of <pattern_str> is the same used for the Select By Regular Expression option on the Set Editor.
Example
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*.