Search found 3 matches

by gabriele
Mon Sep 20, 2010 5:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Combining 2 mdx statements in a string to create subset
Replies: 4
Views: 6633

Re: Combining 2 mdx statements in a string to create subset

Thanks for the reply. However, I want to select both attributes IF (vTargetScenario @= 'Test2');: PlanYear: StringMDX =' {TM1FILTERBYLEVEL ( { DESCENDANTS ( { FILTER ( { TM1SUBSETALL ( [ ' | OverrideDim | ' ] ) } , [ ' | OverrideDim | ' ].[ PlanYear ] = "Y" ) } ) } , 0 ) } '; and FcstYear:...
by gabriele
Sat Sep 18, 2010 1:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Combining 2 mdx statements in a string to create subset
Replies: 4
Views: 6633

Combining 2 mdx statements in a string to create subset

In TI Process I am trying to combine 2 MDX statements into a string to create the subset and get the error "Invalid String Expression". I am using generic code to create subsets that are filtered by level zero, and then overriding some subsets because I do not want these at Level zero. If ...