Using Business Intelligence Analysis : Creating a New Analysis Report : Creating Hyperlinks to a URL
  

Creating Hyperlinks to a URL

This feature allows you to create hyperlinks in an Analysis report that will link to a URL for system to system linking, for example.
The instructions below show you how to create hyperlinks to a URL. You must adjust the instructions to work with your own data.
Important: Hyperlinks take precedence over the drill down feature in charts. That means that if a hyperlink has been defined and you click on a bar in a bar chart, for example, the data associated with the hyperlink, (not the drill down chart), displays.
1. Create a simple Analysis report.
2. Select a row label (or column), right-click, and choose Hyperlink. In the example below, Branch is row label and Day of Week is a column header. Under these, are the individual members that belong to that field/level; for example, Newcastle and Durham are members of Branch. The Link on (Name of Field) appears.
http://infocenter.pentaho.com/help/topic/analysis_guide/images/hyperlink_screenshot.PNG
3. Click Enable Link to activate the hyperlink feature.
You are not creating a hyperlink to the field header itself but rather to the members under the field. You can disable linking at any time by clearing the Enable Link checkbox.
4. Click the down arrow next to Link to and choose URL. The Link on Field Name appears.
5. Enter the URL path. You must use the {FieldNameInsideCurlyBraces} format to pass a parameter in your URL as shown in the example below where {Branch} is the parameter:
http://www.bing.com/search?q={Branch}
You can also define how hyperlink content will display (Open in New Tab, Window, Current Window). Finally, you can enter a tool tip that displays when users hover over the hyperlinks.
6. Click OK to return to your report. Hyperlinks appear in your Analysis report. Click on the links to make sure the content associated with them appears correctly.
http://infocenter.pentaho.com/help/topic/analysis_guide/images/outside_hyperlink.PNG