Parameter Pentaho Report Designer with MDX

Question

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 some of parameters. I have configure a parameter with its own query. The problem is the way the relation between 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 does´t work. What is the mistake? What do i have to do?

Thanks.

Answer 1

what exactly is your mdx? And what error do you get?

The param name needs quoting i.e.

"MDXDate"

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