Mdx Tm1FilterbyPattern

[bskalli]

How can i use 2 Strings in Tm1FilterbyPattern ? only with Union ?
I am near 255 Characters.

Thanks

[standtrue]

You can reference subset names in your MDX, so if you are near your character limit you can break your components up. Say you want to filter a Period dimension so that you have elements that start with "N" and elements that start with "S":

Subset 1("N_Periods"):

{TM1FILTERBYPATTERN( {[period].members}, "N*")}

Subset 2("S_Periods"):

{TM1FILTERBYPATTERN( {[period].members}, "S*")}

Final Subset ("N_and_S_Periods"):

Union(
{[period].S_Periods},
{[period].N_Periods}
)