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.
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.
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.
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.
If you are publishing your report to the Pentaho BA Server, you can use certain BA Server environment variables in your report:
|hostColonPort||The hostname and port number for the BA Server service|
|pentahoBaseURL||The complete URL to the BA Server, as set in the Base URL property.|
|roles||Returns a comma-separated list of roles that the BA Server user who is currently running this report belongs to|
|roles-array||Returns a Java array of strings containing the roles that the BA Server user who is currently running this report belongs to|
|serverBaseURL||The URL to the BA Server, minus the BA 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/biserver-ee/pentaho-solutions/ on Linux and Solaris, and C:\pentaho\server\biserver-ee\pentaho-solutions\ on Windows.|
|username||Returns the BA Server username of the person currently running the published report|