When working with chart dashlets in the Dashboard Designer, you can specify a link that opens when a user clicks the dashlet. You can optionally include a parameter which references an existing filter in another dashlet, and uses that filter to display a specific web page relevant to the filtered information.
The following example takes you through adding a hyperlink to the chart dashlet created in Creating a Web Page Dashlet. The example also shows how to add a parameter to a hyperlink.
First, open the dashboard:
| 1. | If the Key Performance Metric Trend dashboard created in Creating a Web Page Dashlet (above) is not open, locate the /Dashboards folder in the repository. Right-click the dashboard name and select Open in Designer from the context menu. |
The Key Performance Metric Trend dashboard appears in the designer.
Create a chart hyperlink:
| 1. | Right-click on the 08. Key Performance Metric Trend dashlet and select Properties.... |
The Dashlet Properties dialog box opens.
| 2. | Click the Hyperlinks tab. |
| Hyperlinks tab in Dashlet Properties |
|  |
| 3. | Click Enable chart hyperlinks to select it. |
| 4. | Choose Open new page from the Action menu. |
The Web Address/Repository URI entry bar is displayed.
| 5. | Enter repo:/public/Samples/Reports/04._Product_Results_by_Store_Type_Report for the Web Address/Repository URI. |
| | To see the report's path, hover over the report's name in the Existing Content pane. |
Preview the new dashboard functionality:
| 1. | Click Editing button and select Viewing to preview the dashboard. |
| 2. | Click the chart dashlet. |
The 04. Product Results by Store Type Report opens in a new tab.
| 3. | Return to the tab containing Key Performance Metric Trend dashboard and click Viewing button and select Editing to return to the Dashboard Designer. |
Add a parameter:
| 1. | Right-click on the Key Performance Metric Trend dashboard dashlet, select Properties..., and click the Hyperlinks tab. |
The Available Parameters area shows the parameters available in the chart.
| 2. | Modify the URL to add a parameter that provides a value for an input control in the target report: |
| • | You need to know the correct name of the input control in your target report. In this case it is sales__store__store_contact__store_country_1 in the 04. Product Results by Store Type Report. |
| • | Create a parameter. If you create a parameter name, it is helpful to use a name that is not used in Parameter Mapping. In this example, use LinkCountry. For more information about parameters, see Specifying Parameters in Dashlets. |
The link is as follows:
repo:/public/Samples/Reports/04._Product_Results_by_Store_Type_Report?sales__store__store_contact__store_country_1=$P{LinkCountry}
| | If you use one of the names in the Available Parameters list, the mapping to the parameter is created for you. In this example, if you use Store Country instead of LinkCountry, you do not need to create links in Parameter Mapping. This example does not show how to add support when more than one country is selected. For more information, see Specifying Parameters in Dashlets. |
| 3. | Click Map Parameters. Click Yes when prompted. |
Parameter Mapping is displayed.
| Parameter Mapping |
| |
| 4. | In the Store Country filter group, click |
A new row with affected dashlet and filter/parameter drop-down menus appears.
| 5. | In the Dashlet Affected column, select 06. Sales Mix by Gender from the new Select dashlet... dropdown menu. |
| 6. | In the Filter/Parameter Affected column, select LinkCountry from the new Select parameter... dropdown menu. |
Finally, preview the new dashboard functionality:
| 1. | Click Editing button and select Viewing to preview the dashboard. |
| 2. | Click in the Store Country text box to display the available countries. |
| 3. | Select Mexico from the values list, and click Apply at the bottom of the dashlet. |
| 4. | Click the chart dashlet. |
The 04. Product Results by Store Type Report opens in a new tab.
| 5. | To verify that the parameter has been passed correctly, click |
The Input Controls dialog box opens, with Mexico set.
| 6. | Return to the tab that contains your dashboard. |
| 7. | Click Viewing button and select Editing to return to the Dashboard Designer. |
| 8. | Click |
Recommended Comments
There are no comments to display.