Creating Content to Content Links in an Analysis Report

Below are general instructions for creating content links in an Analysis 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.

1. Create a simple dashboard that contains an Analysis Report and a data table. At this point, none of the content has been linked and you have a "static" dashboard.

In the example above, 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.

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 below, a parameter called TERRITORY with a default value of NA has been created.

Note: 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 selecting an item from a filter control or following links defined in content associated with another panel in the dashboard.

Under General Settings, click the data table and examine its available parameters. In the example below, there is an available parameter called TERRITORY with a default source value of NA (North America). A drop-down arrow in the Source text box indicates that there are additional values to control the available parameter. In this example, there are no additional source values that control the TERRITORY parameter.

3. Under General Settings, select the Analysis 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 Analysis report, the values under Territory become hyperlinks.

4. Under General Settings, select the data table and examine its available parameters. Notice that there is a drop-down arrow in the Source text box. Click the down arrow to display and select a new source value for the available parameter. Click Apply.

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