Defining hyperlinks
Manage the amount of information displayed in a report by hyperlinking from one report to other related reports, charts, dashboards, and URLs. For example, you can present basic information in an easy-to-comprehend report with hyperlinks to reports that contain details.
For charts, hyperlinks take precedence over the drill-down chart feature. For example, when readers click a bar in a chart, it displays data related to the hyperlink you define, not the drill-down chart.
For reports, you can define a hyperlink on any row label or column header. When you define a hyperlink, the link is applied to all members within the row or column. In this source report, hyperlinks have been defined for the Positions row level and the Region column level. Notice how each of the row and column members have a blue underlined hyperlink.
When defining hyperlinks to a destination report that has parameters, you can map the row and column levels in the source report to parameters in the destination report. With this function, you can constrain the hyperlink result to display only data for the mapped parameters. If you do not restrain the results, then no filter applies and all the data appears.
Note: If you have renamed a Level in the report, Analyzer continues to display the Level caption or name in the header.
For example, you can create a hyperlink in the source report for all the members in the Position row labels, and constrain the displayed data to only that related to each position and its department. To do this, you map the Department and Positions row levels in the source report to the Business Unit and Job Title parameters in this destination report.
When the reader clicks on the Administrative Assistant position within the Finance department in the source report, it looks like the example below:
Each parameter added to the mapping further constrains the data. You can map any row levels that appear to the left, and column levels that appear above the member data.
Note: If you did not constrain the data with parameters, readers would see data for all Administrative Assistant positions in all departments.
Create hyperlinks to a report in the Pentaho Repository
Create an Analyzer report, or open an existing report.
Right-click a row or column level, then select Hyperlink.
The Link On dialog box appears.
Select Enable Link.
To disable linking, clear the Enable Link check box.
In the Link To drop-down list, select Pentaho Repository File.
Select Browse, locate a report, chart, or dashboard in the Pentaho Repository, then select Open.
If the destination report has parameters, they appear in the Destination Parameter list. Map row and column levels to parameters by selecting the parameter check box. Then enter the row or column level names in curly brackets (
{}).If the destination report does not have parameters, the Destination Parameter list does not appear.
In Open in, select New Tab, New Window, or Current Window.
In Tool Tip, enter the text to show on hover, then select OK.
Test the hyperlinks, then save the report.
Create hyperlinks to URLs
Create an Analyzer report, or open an existing report.
Right-click a row or column level, then select Hyperlink.
The Link On dialog box appears.
Select Enable Link.
To disable linking, clear the Enable Link check box.
In the Link To drop-down list, select URL.
In URL, enter the full address to open.
Example:
http://www.example.comIn Open in, select New Tab, New Window, or Current Window.
In Tool Tip, enter the text to show on hover, then select OK.
Test the hyperlinks, then save the report.
Default hyperlinks
Default hyperlinks let you set links in the schema. You do not need to enable hyperlinks per report.
Once set in the schema, you cannot disable default hyperlinks in Analyzer. You can still edit them.
Create default hyperlinks
Open the Mondrian schema file where you want hyperlinks.
Use Schema Workbench to edit schemas.
Schema workbench In the dimension, add an annotation named
AnalyzerHyperlink.Add the hyperlink as the CDATA value.
Save the schema file.
Dimension values are case-sensitive. Dynamic values must match the dimension name exactly.
Example: An annotation on the Customer dimension uses http://search.yahoo.com/search?p={Customer}. Using {customer} does not work.
Enable default hyperlinks
After you add the annotation, reimport the schema:
In the Pentaho User Console, select Manage Data Sources.
In Manage data sources, open More actions and options, then select Import Analysis.
Manage data sources dialog box Select Browse, select your schema file, then select Import.
The specified dimensions show hyperlinks in new and existing reports associated with the updated cube.
Remove default hyperlinks
Delete the annotation from the Mondrian schema file.
Last updated
Was this helpful?