The Data Pane
The Data pane enables you to add data sources and view the individual queries, functions, and parameters in each report. The three buttons at the top of the pane will add a new data source, function, or parameter when clicked, respectively.
Data Sets
All of the data sources and queries you have defined for the current report will be listed here. If you want to add a new data source, click the leftmost icon (the yellow cylinder) and select the data source type from the ensuing drop-down menu. To add a new query to an established data source, right-click the data source and then select Edit DataSource from the context menu. To delete a data source, select it, then press the Delete key, or right-click it and select Delete from the context menu.
Functions
All of the mathematical functions and conditional elements that you add to a report will be listed in this category. Click the fx button in the upper left corner of the pane to add a new function. You can delete a function by clicking it, then pressing the Delete key, or by right-clicking it and selecting Delete from the context menu.
Parameters
If your query is properly formed, you can add a parameter to your report, which enables report readers to customize the content of the output. To add a new parameter, click the rightmost icon in the upper left corner of the pane. You can delete parameters by selecting the parameter you want to eliminate and pressing the Delete key, or by right-clicking the parameter and selecting Delete from the context menu.
Environment Variables
If you are publishing your report to the Pentaho Server, you can use certain server environment variables in your report:
| Variable | Purpose |
|---|---|
| hostColonPort | The hostname and port number for the Pentaho Server service |
| pentahoBaseURL | The complete URL to the Pentaho Server, as set in the Base URL property |
| roles | Returns a comma-separated list of roles that the Pentaho Server user who is currently running this report belongs to |
| roles-array | Returns a Java array of strings containing the roles that the Pentaho Server user who is currently running this report belongs to |
| serverBaseURL | The URL to the Pentaho Server, minus the Pentaho Server application context name (the default context is /pentaho/) |
| solutionRoot | The path to the top-level Pentaho solution directory. The default location is /home/pentaho/pentaho/server/pentaho-server/pentaho-solutions/ on Linux and Solaris, and C:\pentaho\server\pentaho-server\pentaho-solutions\ on Windows |
| username | Returns the Pentaho Server username of the person currently running the published report |