You must have a report file open in order to proceed, and your data source must be
accessible before you can connect to it in Report Designer. You may need to obtain database
connection information from your system administrator, such as the URL, port number, JDBC
connection string, database type, and user credentials.
Follow this procedure to add a Pentaho Analysis (Mondrian) data source in Report
Designer.
-
Select the Data tab in the upper right pane.
By default, Report Designer starts in the Structure tab, which shares a pane with
Data.
-
Click the yellow cylinder icon in the upper left part of the Data pane, or right-click Data Sets.
A drop-down menu with a list of supported data source types will appear.
-
Select OLAP from the drop-down menu, then select one of the following: Pentaho
Analysis, Pentaho Analysis (Denormalized), or Pentaho Analysis
(Legacy).
The Mondrian Datasource Editor window will appear.
-
If you want to provide parameters that contain different Mondrian connection authentication
credentials, click the Edit Security button in the upper left corner of the window, then
type in the fields or variables that contain the user credentials you want to store as a parameter with this connection.
The role, username, and password will be available as a security parameter when you are
creating your report.
-
Click Browse, navigate to your Mondrian schema XML file, then click Open.
-
Above the Connections pane on the left, click the round green + icon to add a
new data source.
If you installed the Pentaho sample data, several SampleData entries will appear in
the list. These sample data sources are useless if you do not have the Pentaho HSQLDB sample
database installed, so if you don't have that, you can safely delete the SampleData entries. If
you do have Pentaho's HSQLDB samples installed, it may be advantageous to leave the sample data
sources intact in the event that you want to view the sample reports and charts at a later
time.
-
In the subsequent Database Connection dialogue, type in a concise but reasonably
descriptive name for this connection in the Connection Name field; select your database
brand from the Connection Type list; select the access type in the Access list at
the bottom; then type in your database connection details into the fields in the Settings section on the right.
The Access list will change according to the connection type you select; the settings
section will change depending on which item in the access list you choose.
-
Click the Test button to ensure that the connection settings are correct. If they
are not, the ensuing error message should give you some clues as to which settings need to be
changed. If the test dialogue says that the connection to the database is OK, then click the OK button to complete the data source configuration.
Now that your data source is configured, you must enter an MDX query before you can
finish adding the data source. See
Creating an MDX Query for
details.