| Panel |
|---|
June 8, 2006: Dynamically Generating SQL... And More!, from Marc Batchelor, Pentaho Senior Architect and Engineer |
Quick Background
Sometimes, it isn't possible to be able to pre-define your query as a resource or an input to report. Sometimes, it becomes necessary to generate your query (whether it's SQL, MDX, or whatever) using a programming language (such as javascript). Examples of this requirement may involve:
...