Hi,
I have a dashboard that has an "Olap selector" that drives the content of some charts.
These charts use as datasource a query done with "mdx over mondrianJndi".
In this case the condition is:
WHERE ${academicYearFilterParameter}
Now, in the same dashboard, I have a table that uses as datasource a query done with "sql over sqlJndi" that is a simple SQL query.
I'd like to use the Olap parameter into this query but I don't know the syntax.
This syntax doesn't work:
WHERE anno_accademico_ingresso = ${academicYearFilterParameter}because ${academicYearFilterParameter} is an object.
How can modify this condition?
Thank you very much, any help will be appreciated.
Claudio
#Pentaho#PentahoServer