Dynamic Query Scripting
The two following scripting extensions are available in Report Designer:
- Global: used to define shared functions or global variables that are available to all query scripts, and to dynamically change the data source configuration via the init() function.
- Per-Query: used to customize a query string, calculate the "additional fields" information for query-caching, and post-process the returned table model.
Since most production environments separate the server from the design tools, an external script that is local to Report Designer will probably not be local to the Pentaho Server. If you publish a report to the server, you must either change the path to the external script so that it will work on the server, or find a way to include it in the correct relative path on the Pentaho Server.