Please select a Data Access ID

Parameter formulas

You can use formulas instead of fixed values for CDA parameters. Here are some useful examples:

${TODAY()}
Today's date
${YESTERDAY()}
Yesterday's date
$FOREACH(dataAccess,colIdx,param1=val1,...,paramn=valn)
Iterate over the values for 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.

Close

What schedule should this query run on? (advanced)

Ok Cancel