Create a New Query Report Profile

Creating the query report profile is a one-time action. The administrator can edit the report parameters after the query report profile is created, but changes made by an individual user only affect that user’s query and results. The following procedure summarizes the steps involved in creating a new query report profile. A detailed description of each step of the wizard follows the procedure.

To Create a New Query Report Profile:

1. From the Performance Center window, click Performance Desk.
2. In the left navigation pane, click Data Quality Monitor.
   You see the Performance Query Tool workspace.
3. Click the Create link on the toolbar
   You see the Step 1 dialog box of the Query Tool wizard.
4. Define Report Definition by naming the query report profile and selecting the query report view for the query result set. Click Next.
5. Define Default Profile Parameters such as fields, source rule, frequency, and performance model for the data to be retrieved by the query. Click Next.
6. Define Profile Access to grant specific Eagle users and/or business groups access to the query report profile. Click Next.
7. Define Profile Parameters to further define who, among specific Eagle users or business groups with access to the query report profile, has permission to view and edit particular report parameters (for example, fields, source rule, and performance model). These changes do not affect everyone with access to the query report profile. Click Next.
8. Define Operation Access to define the statistical operations in the query report profile that each user can execute with the data once it is returned.
9. Click Finish.

Step 1 in the Query Tool wizard,  allows the administrator to name the query report profile, select a report definition, and enter comments.

To create a query report profile:

1. In the Profile Name box, enter a name for the query.
2. In the Select Report Definition area, select the underlying Report Name.
   The Report Name defines the view or format of the query result set. 
3. Click Next. You are ready to define the default report parameters for the query report profile.

Query Report Views

There are four possible views for the query results. The following table displays the view parameters. 

View 1: Single Entity and No Security Level

View 1 allows a single entity only with the results displayed with the time series dates on the vertical axis and the data fields on the horizontal.

Note that you can include benchmarks for an entity by adding a Performance Analysis field set for the desired benchmark, such as Primary Comparison and Secondary Comparison.

View 2: Multiple Dates, Single Field

View 2 allows you to choose multiple entities, multiple dates, and performance model levels down to security for one data field. The results are displayed with the dates on the horizontal axis and the data field grouped by performance model level. No operations are allowed in this view.

View 3: Multiple Entities Single Date

View 3 allows you to choose multiple entities, multiple performance model levels down to security, and multiple fields for a single date. Results of operations are displayed on the horizontal axis. This view is most similar to the Performance Analysis report. Due to the nature of the result set, rolling period operations are limited to one repetition, which is well suited to “to-date” operations like inception-to-date or year-to-date as of the report date.

View 4: Multiple Entities, Dates and Fields

View 4 allows you to choose multiple entities, performance model levels down to security, dates, and fields.

By default, the results are grouped by Entity, each Performance Model level, and the time series of dates. For example, the fund total for each date in the date range, then the Equity Total for each date, then each Equity security for each date. Data and operation fields are displayed on the horizontal axis.

Define the Default Report Parameters

Step 2 in the Query Tool wizard, Define Default Report Parameters, allows the administrator to define the default report parameters for the query report profile. Report parameters specify the performance data that is returned by the query when it is submitted (for example, fields, source rule, performance model, frequency, and so on).

The report parameters are not always known by the analyst or downstream users, so they are set by the administrator as default values. A value is required for all of the default report parameters.

The Define Default Profile Parameters dialog box includes a series of report parameters which you can define. The following sections describe each report parameter.

Currency Conversion

Select a target currency from the list to convert Query Tool values from the entity’s base currency to the specified target currency.

Performance Status Flag

Select a value to show only the performance data that has the status or statuses specified in this field. Options include:

• All Records, the default value
• Preliminary Only
• Final Only
• Preliminary Or Final
• Not Preliminary Or Final

Fields

Click the ellipsis to the right of Fields to select the fields you want to display on the report. The first field to select, for all report views except view 2, is a field attribute that is pointed to the column Performance end date on the PERF_SUMMARY table in the PERFORM database, as shown in the following figure. In the following figure, the field attribute is named Perf End Date. This field attribute has different names in different environments, but should be found in the Performance folder.

Next, select the Performance Analysis fields that point to the data you want returned in the query report, as shown in the following figure. Performance Analysis fields are found under the Custom category and are designed to retrieve the single-period data that is stored in the PERFORM database. It is not necessary to select Performance Link Analysis fields because Operations such as linking are done on the fly in the Query Tool. See “Performance Analysis Fields Supported in the Query Tool” for more details on functionality.

Source Rule

The source rules are created in the General Reporting area of PACE, as shown in the following figure. The source rule determines the hierarchy of sources to use when selecting performance data from the database. This means the source used to commit or load the performance data needs to be listed in the Performance category of the Source Rule.

Performance Model

Select a performance model, also known as the performance dictionary. See the following figure. Performance models are created either when you calculate returns in Eagle Performance or via an uploader. The performance model represents the grouping structure of the performance data, such as Fund/Country/Sector or Fund/Coupon Range. If fund and benchmark returns are stored in different models, the default dictionary functionality can retrieve the benchmark returns from a different model.