[Mondrian] Using parameters in Pentaho Report Designer 3.5 -- issue with formulas
filcole at gmail.com
Wed Nov 4 06:41:57 EST 2009
Pedro was a bit of a legend and worked out a way for the date picker to feed the current date into an MDX query.
First you have to change the java date returned by the date picker to a java string using open formula in the report. E.g. MDXDateStr equals [Date].[All Years]..[Q1].[MAR]. and then pass this in as a parameter to an MDX query in a subreport.
More information about the Mondrian