TM1 Forum

here's the subset code for dimension B {TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL( {TM1SUBSETALL( )}, 1)}, "*=>*" )} The above will work, but I really want to use A as the beginning of the pattern. something like this: {TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL( {TM1SUBSETALL( )}, 1)}, [CUBEX].([A...

hi all, i have a question about TM1 mdx. i have a dimension A and want to create a dynamic subset on dimension B where B's name starts with A. Is this possible in TM1? I am getting some error with TM1FILTERBYPATTERN if I try to use anything besides a hard-coded string pattern like "*--*".....