Parameter Pentaho Report Designer with MDX

I am doing a report, using Pentaho Report Designer. My datasource is a Mondrian Cube with MySQL JDBC. I am using MDX queries, and I want to put paramerize开发者_C百科 it. I have to configure a parameter with its own query.

I'm having trouble relating the main query and the parameter query. For that, I am using the function parameter in this way: where (strToMember(Parameter(name,type,default_value))) but it doesn´t work. What is the mistake? What do I have to do?

Thanks.

---

What exactly is your MDX query? And what error do you get?

The param name needs quotation marks surrounding it, i.e.

"MDXDate"

Alternatively you can just use ${paramname}, but the disadvantage of that is you won't be able to use the preview option.