Skip to main content
Pentaho Documentation

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.

The Report Designer Data Pane

Environment Variables

If you are publishing your report to the Pentaho BA Server, you can use certain BA Server environment variables in your report:

Variable Purpose
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