When parameter name is a function name

Post Reply
User avatar
yyi
Community Contributor
Posts: 117
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

When parameter name is a function name

Post by yyi » Sat Dec 17, 2016 2:42 am

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
win2012 svr: tm1 v10.2.2 x64, client v10.2.2 x64/PA 2.0, win10, excel 365.

lotsaram
MVP
Posts: 3342
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: When parameter name is a function name

Post by lotsaram » Sat Dec 17, 2016 7:56 am

Or you could just rename the parameter.
E.g. "pMonth"
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

User avatar
yyi
Community Contributor
Posts: 117
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

Re: When parameter name is a function name

Post by yyi » Mon Dec 19, 2016 6:04 am

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 :(
win2012 svr: tm1 v10.2.2 x64, client v10.2.2 x64/PA 2.0, win10, excel 365.

Post Reply