Linking to Generic Performance Scorecard Reports

You can create generic reports in Performance Scorecard that have different requirements than the default reports. For example, create generic reports to reflect multiple measures and queries. Add links to these reports on the Performance Scorecard Browser View as follows.

  To create links to generic reports:

  1. Select File, and then Scorecard Configuration.

  2. Select Reports.

  3. Click Add Report.

    The Report Setup is displayed.

  4. Under Select Report Type, select Generic.

    The Generic Report Setup is displayed.

  5. Under Name, enter a unique name for the Oracle's Hyperion® Interactive Reporting or Business Intelligence report.

  6. If you are creating a Business Intelligence report, select BI. If you are creating an Intelligence Reporting report, select IR:

    The name and port number of the Interactive Reports sever is displayed, and the location of the BQY and OCE files.

  7. Specify values for these Parameters:

    • ScorecardName—Name of the selected scorecard

    • MeasureName—Name of the selected measure

    • Date—Date for which to generate the report in ddMMyyyy format

    • DimensionName—Name of the selected dimension

    • Query—Enter true to use a query. Otherwise enter false

  8. Optional: Click Add to create an additional row for new parameters and values. Repeat this step to add as many rows as required.

  9. Click Save.

    The name and URL for the new report are added to the list of external reports.

  10. Optional: Select Launch in New Window to display the report in a new browser window when viewed.

  11. Click Save.

  12. Optional: Add the new link to the Report Type list:

    1. Navigate to ReportTypes.xml to add the report type and name. By default, this file is installed in:C:\Hyperion\hps\9.5\AppServer\InstalledApps\Embedded Java Container (Tomcat)\5.0.28\webreportsDomain\webapps\HPSWebReports\WEB-INF\classes

    2. Locate this section of code:

      <ReportType name=”Test” type=”IR” sortOrder=”4” port=”19000” server=”localhost” location=”workspace/browse/get/HPSWebReorts/Test.bqy”

    3. Add the new report name and type to the list before the final /ReportType tag, using this format:

      parameter name=”(report)” type=”(report type)” sortOrder”(sequence on report list)” required=”(True or False)”/>

      Note:

      To use a special character such as an apostrophe, enter a backslash (\), before the character. For example, LastQuarter\'s Financial Report.

      The report is displayed in the Custom Reports folder on the Browser View.