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
When parameter name is a function name
-
- 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
Or you could just rename the parameter.
E.g. "pMonth"
E.g. "pMonth"
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Re: When parameter name is a function name
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