Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Link an Analyzer report

Parent article

You can link from either a graphic element or a hyperlink in an Analyzer report.

Create graphic element links to a report

You can create content-to-content links between an Analyzer chart and any other parameterized report such as a Report Designer report, a data table, or another Analyzer report.

Below are general instructions for linking an Analyzer chart to a report. You must adjust the instructions when working with your own data.

Procedure

  1. Create a simple dashboard that contains an Analyzer chart and a parameterized report.

    The example here displays an Analyzer chart and an Analyzer report displayed as a table view. At this point, none of the content has been linked and you have a "static" dashboard.

    Hypothetically, if you want users to be able to click a bar in the bar chart and update the Analyzer table view, the table must contain at least one parameter. In the example below, there are two parameters, (LINE and TERRITORY), associated with the Analyzer table.

    Parameter created for LINE
  2. Under General Settings, choose the Analyzer chart, then click the Content Linking tab.

  3. Click the check box (or check boxes) next to the field/column name you want enabled for content linking, and then click Apply.

    Chart content linking
  4. Under General Settings, choose the Analyzer report (table view) and click the Parameters tab.

  5. Click the down arrow in the Source text box to display another source for the parameters you created.

    In the example below, notice that Sales by Line, (this is the name of the dashboard panel that contains the chart), can now be selected as a source for both the TERRITORY and LINE parameters. Select source on Parameters tab
  6. Save your dashboard.

    See Saving Dashboards for steps.
In this example, content linking is applied when users double-click a bar in the bar chart. The data table updates and displays sales details for a product line in a specific territory. Content linking example

Create hyperlinks to a report

Below are general instructions for creating content links in an Analyzer report, (inside a dashboard), that can be used to drive the parameter values of content in other dashboard panels. You must adjust the instructions when working with your own data.

Procedure

  1. Create a simple dashboard that contains an Analyzer report and a data table.

    At this point, none of the content has been linked and you have a "static" dashboard.

    In the example here, when content linking is achieved, the list of territories (APAC, EMEA, Japan, and NA) will become hyperlinks that, when clicked, will update customer details data table. To get the correct filter display, a parameterized query that drives the content in the data table must be created.

    Content linking for a table
  2. Add a parameterized condition to the query for the data table by specifying a parameter name in curly braces in the Value text box; then, provide a default value for that parameter in the Default text box.

    In the example here, a parameter called TERRITORY with a default value of NA has been created. Parameterizing a query, as described here, allows you to pass values dynamically and update the chart based on events triggered by other elements of the dashboard such as a user choosing an item from a filter control or following links defined in content associated with another panel in the dashboard. Query on territory
  3. Under General Settings, choose the Analyzer report. Click the Content Linking tab then click the check box next to the field/column name you want enabled for content linking. Click Apply.

    In the Analyzer report, the values under the Territory become hyperlinks.Hyperlinks in Analyzer table
  4. Under General Settings, choose the data table and examine its available parameters. Click the drop-down arrow in the Source text box to display and choose a new source value for the available parameter, then click Apply.

  5. Save your dashboard.

In the example below, content linking was applied. When users click a territory hyperlink in the Analyzer report, the data table updates and displays customer-related details associated with that specific territory exclusively. Content link in Analyzer table