Hyperion SQR Workspace Link

Defines URLs for target items in EPM Workspace. These URLs enable "report surfing," or creating hyperlinks between content of any type. For example, a white paper can link to a glossary document, and a sample code listing can link to a job that runs the code and returns output.

Report surfing enables complex output structures, such as "drill-down" reports. For example, you could link a heading titled "Sales Compensation" to current policy in the Human Resources section of EPM Workspace.

Field	Description
Report Path	Path to the report to which you are linking and the Production Reporting program file name. The Report Path is a relative path. If the report to which you are linking is in the same directory as the directory where you are publishing the report, enter the name of the report in the Report Path field. If the report to which you are linking is in a different directory, enter the relative location of the report along with the report name. For example, if you had a report titled salesreport in your /sales/shipments directory, and the report from which you are linking will be published to the sales directory, you would enter shipments/salesreport in the Report Path field. The Report Path is case-sensitive. If you entered Shipments/salesreport for the path in the above example, you would not be able to locate the report. When specifying the Production Reporting program file name, do not enter a file extension. To link to Production Reporting program output instead of executing an Production Reporting program, include –frm.htm in the name. In the above example, you would enter shipments/salesreport.htm_frm to link to the existing Production Reporting sales results html report. To link to another type of file, enter the name as specified in Wrokspace. If you do not know the correct name of the object, look in EPM Workspace to view the contents.
Prompts	Prompts limit the report to specific information. For example, you could add prompts to limit a report to customers in the South-Eastern region and sales in the fourth quarter. To add a prompt, click Add to access the Prompt dialog box. Any prompt that you enter in the Prompt dialog box appear in the Prompts section of the Hyperion SQR Workspace Link dialog box.

Field

Description

Report Path

Path to the report to which you are linking and the Production Reporting program file name.

The Report Path is a relative path. If the report to which you are linking is in the same directory as the directory where you are publishing the report, enter the name of the report in the Report Path field.

If the report to which you are linking is in a different directory, enter the relative location of the report along with the report name. For example, if you had a report titled salesreport in your /sales/shipments directory, and the report from which you are linking will be published to the sales directory, you would enter shipments/salesreport in the Report Path field.

The Report Path is case-sensitive. If you entered Shipments/salesreport for the path in the above example, you would not be able to locate the report.

When specifying the Production Reporting program file name, do not enter a file extension.

To link to Production Reporting program output instead of executing an Production Reporting program, include –frm.htm in the name. In the above example, you would enter shipments/salesreport.htm_frm to link to the existing Production Reporting sales results html report.

To link to another type of file, enter the name as specified in Wrokspace. If you do not know the correct name of the object, look in EPM Workspace to view the contents.

Prompts

Prompts limit the report to specific information. For example, you could add prompts to limit a report to customers in the South-Eastern region and sales in the fourth quarter. To add a prompt, click Add to access the Prompt dialog box. Any prompt that you enter in the Prompt dialog box appear in the Prompts section of the Hyperion SQR Workspace Link dialog box.