Using Business Intelligence Dashboard Designer : Using Content Linking to Create Interactive Dashboards : Content Linking and Query Parameters : Linking an Action Sequence Parameter to Content in other Dashboard Panels
  

Linking an Action Sequence Parameter to Content in other Dashboard Panels

To complete this task you must have an action sequence (.xaction) that contains at least one parameter.
Below are general instructions for allowing an Action Sequence parameter to drive the filter associated with content in another dashboard panel. You must adjust the instructions when working with your own data.
 
1. Create a simple dashboard that contains an action sequence file and a data table. At this point, none of the content has been linked and you have a "static" dashboard. 
http://infocenter.pentaho.com/help/topic/puc_user_guide/images/74_xaction_content_linking.png
Notice the chart (action sequence file) in the example above. You want dashboard consumers to click on a territory (APAC, EMEA, etc.), bar and have the data table update with information about that territory specifically.
2. Under General Settings, select the action sequence file and click Content Linking. If parameters have been defined in the action sequence, they will appear as values to be enabled for content linking. Parameters are hard-coded in the action sequence and cannot be changed.
http://infocenter.pentaho.com/help/topic/puc_user_guide/images/75_xaction_content_linking_available_parm.png
3. 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.
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 EMEA. A drop-down arrow in the Source text box indicates that there is an additional value to control the available parameter. The value comes from the parameter in the action sequence.
http://infocenter.pentaho.com/help/topic/puc_user_guide/images/76_xaction_content_linking_drop_down.png
4. Save your dashboard. See Saving Your Dashboard below.
5. In the action sequence file click on an object such as a bar as shown in the example above. The content in the data table updates in response to the object that was clicked in the action sequence.