TM1 Forum

I was going to post this question but by the time I found my password for the forum, came up with the answer already. In case anyone else had this question I thought I'd share what happened;

Cube with dimension name called "year" or "month" >> create drill process >> use dimension element name to construct sql where statement.
eg: vMonth = month >> TI breaks
A: vMonth = expand('%month%') >> TI ok

Or you could just rename the parameter.
E.g. "pMonth"

Thanks lotsa, I'm not sure why it didn't work when I changed it the first time - so I thought I had to keep it the same as the dimension name. Such an eeeeasy thing, should have just tried re-saving the process again. Feels a bit like the prolog contents disappearing sometimes when it gets a syntax error on save