Using Business Intelligence Dashboard Designer : Using Content Linking to Create Interactive Dashboards : Content Linking and Query Parameters : Linking an Analysis Chart to a Report
  

Linking an Analysis Chart to a Report

You can create content-to-content links between an Analysis chart and any other parameterized report such as a Report Designer report, a data table, or another Analysis report.
Below are general instructions for linking an Analysis chart to a report. You must adjust the instructions when working with your own data.
1. Create a simple dashboard that contains an Analysis chart and a parameterized report. The example above displays an Analysis chart and an Analysis 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 on a bar in the bar chart and update the Analysis table view, the table must contain at least one parameter. In the example below, there are two parameters, (LINE and TERRITORY), associated with the Analysis table.
http://infocenter.pentaho.com/help/topic/puc_user_guide/images/ana_param_on_line.png
 
2. Under General Settings, select the Analysis chart. Click the Content Linking tab then click the check box (or check boxes) next to the field/column name you want enabled for content linking. Click Apply. 

http://infocenter.pentaho.com/help/topic/puc_user_guide/images/ana_chart_content_linking_sample.png
3. Under General Settings, select the Analysis Report (table view) and click the Parameters tab. 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.

http://infocenter.pentaho.com/help/topic/puc_user_guide/images/ana_content_linking_selections_territory.png
4. Save your dashboard. See Saving Your Dashboard below.
 
In this example, content linking is applied when users click on a bar in the bar chart. The data table updates and displays sales details for a product line in a specific territory.
http://infocenter.pentaho.com/help/topic/puc_user_guide/images/ana_chart_content_linking_final.png