Within Interactive Reports, a report is stored as a BQY file. This file contains the formatting and structure for the report.
These sample BQY files are provided:
Scorecard.bqy. See Scorecard Report
Scorecard_withMeasureTrend.bqy. See Scorecard with Measure Trends
StrategyDashboard.bqy. See Strategy Scorecard
You can modify these files used for the default reports as a starting place to create your own customized reports.
To import BQY files:
On the View Pane, navigate to the location of the BQY folder.
Right-click on the folder to display the shortcut menu, and select Import File to access the sample reports.
Under File, click Browse to navigate to the BQY file, then click Next. By default, the sample files are located in
install\Middleware\EPMSystem11R1\products\PerformanceScorecard\AppServer\InstallableApps\common\Reports\Template_BI+.Select the users, roles or groups who are to be given access to the report from the Available Users, Groups and Roles list.
Move the identified users to the Selected Users, Groups and Roles list.
From Edit Permissions, select the appropriate level of Access to File, such as No Access or Full Control.
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.
From the Properties dialog box, click OK to save the new permissions.
The IR Properties tab is displayed. This tab is used to associate the queries with the BQY file.
From the Set all queries to obtain the username/password: list, select From OCE Default.
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.
The Username Password and Options information is automatically populated. The report is published and available in Performance Scorecard. SeeGenerating an Interactive Reporting Report.