When parameter name is a function name

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

When parameter name is a function name

Post by yyi »

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
Yeon
lotsaram
MVP
Posts: 3661
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 »

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: 121
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

Re: When parameter name is a function name

Post by yyi »

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 :(
Yeon
Post Reply