Importing the BQY File

Within Interactive Reports, a report is stored as a BQY file that defines the format and structure.

These sample BQY files are provided:

Use these files as a basis for creating your own reports.

  To import BQY fileS:

  1. Log on to EPM Workspace as an Administrator.

  2. On the View Pane, navigate to the location of the .OCE folder.

  3. Right-click on the folder to display the shortcut menu, and select Import File to access the sample BQY reports.

  4. Under File on the Choose File tab, click Browse to navigate to the location of the selected BQY file, then click Next. By default, the sample files are located in C:\Hyperion\products\PerformanceScorecard\AppServer\InstallableApps\common\Reports\Template_BI+.

  5. Click Next.

    The Choose File tab is displayed.

  6. From the Choose File tab, click Edit Permissions to display the Properties page to set the access level for the reports.

  7. Select the users, roles or groups who are to be given access to the report from the Available Users, Groups and Roles list.

  8. Move the identified users to the Selected Users, Groups and Roles list.

  9. Click Edit.

  10. From Edit Permissions, select the appropriate level of Access to File, such as No Access or Full Control.

  11. Select the Adaptive State, or the level of access the user will have to modify the report, such as View Only or Query and Analyze.

  12. Under Favorite, select Inherit or Pushed.

  13. Click OK to close the Edit Permissions dialog box.

  14. From the Properties dialog box, click OK to save the new permissions.

  15. Click Next.

    The IR Properties tab is displayed.

  16. From the Set all queries to obtain the username/password: list, select From OCE Default.

  17. From Connection, select the OCE file for each Query/Data Model Name.

    The Username Password and Options information is automatically populated from the OCE file.

  18. Under Interactive reporting Options, select Enable ADR.

  19. Click Next.

    The Username Password and Options information is automatically populated from the .OCE file. The report is now published and available for generation in Performance Scorecard.