You can use SQR Production Reporting Studio to define URLs for target items in EPM Workspace. When used with EPM Workspace items, 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 where you can drill down to levels of detail. For example, you could link a heading titled “Sales Compensation” to current policy in the Human Resources section in EPM Workspace.
To build a URL for an item in EPM Workspace:
In the report layout, double-click an object or right-click the object and select Object Properties.
Click the HTML tab.
Select Create Link and click Build Hyperion SQR Workspace Link
The Hyperion SQR Workspace Link dialog box is displayed
In Report Path, enter the 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.
If the report to which you are linking is an another 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.
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_frm.htm to link to the Production Reporting html sales report.
To link to another type of file, enter the name as specified in EPM Workspace. If you do not know the correct name of the item, look in EPM Workspace to view the contents.
To add other column values to your URL, click
and select the desired columns in the Insert Column Values dialog box.See Graphically Adding Column Values to URLs and Anchors for more information.
Click Add to access to Add Prompt dialog box where you can define default values to use when running the report.
For example, you could add values to limit the report to customers in the South-Eastern region and sales in the fourth quarter.
Table 20. Prompt Display Options
Option Description When you first access the Add Prompt dialog box, SQR Production Reporting Studio attempts to calculate the next available prompt number based on the existing prompts. You can override the prompt number if desired. Multiple prompts must be sequential. You cannot add prompts 1, 2, and 4 without adding prompt 3, for example.
Note: To determine the number and type of prompts a report in EPM Workspace contains, open the Production Reporting Job Publisher on the Job Utilities toolbar, select the item in the Content pane of the main Production Reporting Job Publisher screen, and click Show Properties.
Input—User-entered data.
Ask—Compile-time prompts. Retrieval may be by user input, command-line arguments, or as entries in the @file on the command line.
Note: For more information on Input and Ask prompts, see Volume 2 in the Hyperion SQR Production Reporting Developer's Guide. You can also view the report properties in the Production Reporting Job Publisher to determine the required prompt type.
Click
to add column values to the prompt,. (See Using Column Values as Part of URLs and Anchors .)