You can use formulas instead of fixed values for CDA parameters. Here are some useful examples:
${TODAY()}
${YESTERDAY()}
$FOREACH(dataAccess,colIdx,param1=val1,...,paramn=valn)
colIdx
in query dataAccess
with the given parameters. Queries using this construct return no values, and its main purpose is to provide parameter ranges for cache warming.Please refer to the Pentaho Reporting Engine documentation for a full description of the syntax.
What schedule should this query run on? (advanced)