To run the Performance Analysis report, you create a Performance Analysis report profile, as shown in the following figure.
The report profile works like other PACE drill-down reports, except for the additional requirement to set the level at which the risk, contribution, and attribution statistics are calculated. The report uses the returns and weights at the level of the Performance Model you select in the Analysis option section to calculate risk, contribution, and attribution statistics. You can also specify whether you want the report to let you drill down below that level to view results.
When you get the report results back, you can drill down to stock level, query the database for things like the time series of prices or analytics for the security, export the results to Microsoft Excel, and so on. See the following figure.
The Performance Analysis report can also link returns to generate a multi-period performance analysis. The following figure shows a monthto-date performance comparison report.
Common Profile and Report Type Information
PACE maintains information that is used to determine profile instances and report types. The Performance Calculation and Composite Weighted Return reports populate this information.
Create a Performance Analysis Report Profile
The Performance Analysis report profile provides a template for creating multiple period risk and returns.
To create a Performance Analysis report profile:
- From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
- Enter Reporting in the Start Search text box.
- Click the General Reporting (Performance Center) link to access the Performance Center.
You see the Performance Center with the General Reporting workspace. - Click the Reports tab.
The Reports Explorer appears. - In the report categories area, expand the Reports folder, select the Performance Analysis folder, and click Compose.
- In the Building a new Report Profile pane, the system highlights Performance Analysis.
- Under Pick a type of Report, select Double click here to build your report.
The Creating a Performance Analysis Report dialog box appears, with three pages of options. The options for the report profile are similar to those for other PACE drill-down reports, with the exception of several options specific to Eagle Performance.
Option
Description
Entities
The entities to include in the Performance Analysis report, selected from the Entity Selector. For more information, refer to the PACE Reporting Reference Guide.
Effective Date period
The date period to use for the report. Options include:
- Current Date
- Current Date - recent for all entities
- Previous Date
- Previous Date - recent for all entities
- Current Month
- Today
- Yesterday
- Previous Month
- As of
- From the Date Rule
- Link Period Override
Link Period Override (Date Rule)
For information about the Link Period Override options, refer to "Overriding Link Periods in Underlying Fields." For information about using standard date rules in reports, refer to the PACE Reporting Reference Guide.|In the first page, Step 1 of 3, define the information described in the following table. See the previous figure.
Report rule The report rule to use for the report. For more information, refer to "Performance Analysis Report Rule" and the PACE Reporting Reference Guide. Analysis option This link allows you to define a set of Calculation & Display level options and Dynamic Performance options. You cannot define these options until you specify a report rule for the report profile.
A description of these options follows in "Understanding the Analysis Options."Additional options The Options button allows you to define the following types of information in the Advanced Options dialog box:
- Data filter options in the Specify Filter tab. For general information, refer to the PACE Reporting Reference Guide. For information about using filters for dynamic performance, refer to "Classifications, Filters, and Range Rules."
- Currency conversion options in the Select a Currency tab. For more information, refer to "Converting Returns From One Base Currency to Another."
In Step 2 of 3, define the information described in the following table. See the previous figure.
Option
Description
Scheduling Options
You can schedule report profiles to run at the same time every day or as part of an overnight cycle of scheduled reports. For information, refer to the PACE Reporting Reference Guide.
Report Options
Clicking the Options button displays the Report Options dialog box, where you can define standard reporting and distribution options described in the PACE Reporting Reference Guide. The following nonstandard options apply to Eagle Performance:
- Use this language for the Report. If you set up Eagle to support languages in addition to English, you can specify a different language to use for the report results. The default language is English.
- Include TOTAL row in results. Determines whether the report displays the Total row. By default, this check box is cleared, and the Total row does not appear. For more information, refer to "Displaying and Hiding the Total Row."
- Set Report Thresholds. Allows you to control the number of entities and time periods used when running the report. For more information, see "Setting Report Threshold for Entities and Time Period."|
In Step 3 of 3, define the options to name the report and so on. See the previous figure.
For more information about these standard options, refer to the PACE Reporting Reference Guide.
- Click Finish to save your changes for all pages of the dialog box.
After you define the report profile, you can run the report and view the report results.
Run the Performance Analysis Report on an Ad Hoc Basis
You can use the Submit with Overrides option to temporarily change several types of Performance Analysis report attributes before you submit the report. This option is useful for submitting published reports, because the only person who can change the published report is the report owner.
To run a Performance Analysis Report on an ad hoc basis:
- From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
- Enter Reporting in the Start Search text box.
- Click the General Reporting (Performance Center) link to access the Performance Center.
You see the Performance Center with the General Reporting workspace - Click the Reports tab.
The Reports Explorer appears. - In the report categories area, expand the Reports folder, click the Performance Analysis folder, and identify the report you want to run.
- Right-click the report name, and select Submit with overrides from the shortcut menu. See the previous figure.
- Alternatively, you can select the report, click the drop-down list arrow beside the Submit option on the toolbar, and select the Submit with overrides option from the toolbar.
The Submit with Override dialog box appears for the selected report. See the following figure.
This dialog box includes a series of tabs where you can enter values that temporarily override the options associated with the report profile and its assigned report rule. - You can use the Select Date(s) and Entity(ies) tab, shown in the previous figure, to:
- Override the dates defined in the report profile. For more information, refer to "Creating a Performance Analysis Report Profile."
- Override the server log level used for the report. For more information, refer to "Performance Analysis Logging."
- Override the entities defined in the report profile.
- Select a language for the Report. If you set up Eagle to support languages in addition to English, you can specify a different language to use for the report results. The default language is English.
The report can include multilingual security field attributes such as security name, entity field attributes such as portfolio name and benchmark name, and performance model information such as GICS sector. For general information about generating OLAP report results in multiple languages, refer to the PACE Reporting Reference Guide.
- Generate EagleEye Analysis output for use in report troubleshooting. For more information, refer to "Chapter 6: Using EagleEye Analysis."
You can click the Select a Report Rule and a Field Rule tab to override the report rule associated with the report profile, and/or override the field rule specified in the selected report rule. See the previous figure.
For more information, refer to "Performance Analysis Report Rule" and "Performance Analysis Fields."
- You can click the Select the Grouping Rule tab, shown in the previous figure, to override the:
- Grouping Rule. Grouping rule associated with the selected report rule. Overriding the grouping rule allows you to select different performance models or dynamic grouping by using a grouping that differs from your standard performance model. This process, called Dynamic Aggregated Performance Analysis, allows you to perform "what-if" analysis without rerunning and committing historical performance for the grouping in a new performance model. It also allows you to "look through" a compound instrument, such as an Exchange Traded Fund, into its constituents to see a true exposure. For general information about grouping rules, refer to "Performance Analysis Report Rule." For more information about using dynamic groupings, refer to "Chapter 5: Using Dynamic Aggregated Performance Analysis."
- Analysis Options. For more information, refer to "Understanding the Analysis Options."
- Global Attribution Options. You can override the Global Attribution Group field's Options and Field Map to use for the analysis in attribution reports. This option is available when the fields in the Field Rule of the underlying report only contain Global Attribution fields from a single Global Attribution Field Group. If multiple Global Attribution Field Group fields are present in the attribution report's Field Rule, then this option is unavailable. For more information, refer to the Attribution User Guide.
- You can click the Select the Currency tab to override the currency conversion options associated with the report profile. See the previous figure.
For more information, refer to "Converting Returns From One Base Currency to Another."
- You can click the Select the Benchmark tab to override the benchmark assignments associated with the entities selected for the report. See the previous figure.
For more information, refer to "Overriding a Benchmark – Submit with Override."
- Click OK to submit the report.
Understand the Analysis Options
This section describes the analysis options in the Performance Analysis report. See the following figure.
These options become available when you click the Analysis option link in the report profile. For more information, refer to "Creating a Performance Analysis Report Profile." You can also use the Submit with Overrides option to temporarily change analysis options before you submit the report. For more information, refer to "Running the Performance Analysis Report on Ad Hoc Basis."
You can use the analysis options to specify the level of report output results and to define settings used in attribution reports and dynamic performance reports. You cannot define these options until you specify a report rule for the report profile.
The following table describes the analysis options.
Option | |
---|---|
Calculation & Display Level | |
Selected level to calculate attribution and display results down to | Specifies the lowest level of the performance model at which the report uses returns and weights to calculate risk, contribution, and attribution statistics. |
Limit results to the level selected above | If you set the prior field to a performance model level other than Security Level, this option allows you to limit the results you retrieve and display. It determines whether the report displays all results or only displays results down to the level specified in the prior field. If displaying results down to a selected level, you can specify whether the report retrieves security level data for rollup purposes, and whether the report additionally displays security level data. Options include:
|
Show attribution inputs below selected level | For attribution reports, do one of the following:
|
Suppress benchmark data not held by the profile portfolio | Select this check box to exclude benchmark data in the results for securities where the benchmark includes holdings that the related portfolio does not hold. |
Dynamic Performance | |
Portfolio Look Through | In dynamic performance reports, select this check box to use portfolio look through. This option is available only if you do not select a performance model as the report's grouping rule. For more information, refer to "Invoking Portfolio Look-Through." |
Adjust Securities Values to Match Parent | This checkbox becomes active when you select the checkbox for Portfolio Look Through. Check this box to adjust the returns of underlying securities by a drift factor so that they roll up to match the return of the look-through security they replaced. |
Apply Filter for Benchmark | In dynamic performance reports, select this check box to apply data filters to the benchmark. This option is available only if you do not select a performance model as the report's grouping rule. For more information, refer to "Classifications, Filters, and Range Rules." |
Limiting Results Examples
The Limit results to the level selected above option affects whether you can view security level data directly below intervening performance model levels after you commit data once to a performance model. Assume you use a performance model that groups data by Total / Region / Country / Security. The following examples illustrate what results display if you select various options for limiting results.
Do not limit results. In the following example, if you select a performance model level of Region and set this option to Do not limit results, you see results like the following.
Total | ||||
North America | ||||
United States | ||||
Security 1 | ||||
Security 2 | ||||
Canada | ||||
Security 3 | ||||
Security 4 | ||||
Europe | ||||
France | ||||
Security 5 | ||||
Security 6 | ||||
Germany | ||||
Security 7 |
Limit results or Limit results, fetch but do not display securities. In this example, assume you select a performance model level of Region and set this option to Limit Results or to Limit results, fetch but do not display securities. You see results like the following.
Total | ||||
North America | ||||
Europe |
Limit results, fetch and display securities. In this example, you select a performance model level of Region and set this field to Limit results, fetch and display securities. You can see results like the following. Notice that you can see the securities below each region, and those securities are not grouped by Country, the intervening performance model level.
Total | ||||
North America | ||||
Security 1 | ||||
Security 2 | ||||
Security 3 | ||||
Security 4 | ||||
Europe | ||||
Security 5 | ||||
Security 6 | ||||
Security 7 |
Report Outputs from Calculation & Display Level Settings
The following table summarizes the report outputs that you can produce by combining the following Calculation & Display Level option settings. The report processing shown is designed to provide more recent functions while preserving backward compatibility for existing report profiles.
Field Types Included in Field Rule | Calculate Attribution Statistics at the Level | Limit Results to the Level Selected Above | Show Attribution Inputs Below Selected Level | Report Processing |
---|---|---|---|---|
Mixed Performance Analysis and attribution group | Total or rollup | Do not limit results | Cleared | Data is retrieved to security level, attribution is calculated from selected level, non-attribution data is displayed down to security level. |
Mixed Performance Analysis and attribution group | Total or rollup | Do not limit results | Selected | Data is retrieved to security level, attribution is calculated from selected level, all data is displayed down to security level. |
Mixed Performance Analysis and attribution group | Total or rollup | Limit results | Cleared (Unavailable) | Data is retrieved to selected level, attribution is calculated from selected level, all data is displayed down to selected level. |
Mixed Performance Analysis and attribution group | Total or rollup | Limit results, fetch but do not display securities | Cleared (Unavailable) | Data is retrieved to security level, attribution is calculated from selected level, all data is displayed down to selected level. |
Mixed Performance Analysis and attribution group | Total or rollup | Limit results, fetch and display securities | Selected (Unavailable) | Data is retrieved to security level, attribution is calculated from selected level, all data is displayed down to security level. |
Mixed Performance Analysis and attribution group | Security | Do not limit results (Unavailable) | Cleared (Unavailable) | Data is retrieved to security level, attribution is calculated from security level, all data is displayed down to security level. |
Attribution group only | Total or rollup | Do not limit results | Selected | Data is retrieved to security level, attribution is calculated from selected level, all data is displayed down to security level. |
Attribution group only | Total or rollup | Limit results | Cleared (Unavailable) | Data is retrieved to selected level, attribution is calculated to selected level, all data is displayed down to selected level. |
Attribution group only | Total or rollup | Limit results, fetch and display securities | Selected (Unavailable) | Data is retrieved to security level, attribution is calculated from selected level, all data is displayed down to security level. |
Attribution group only | Security | Do not limit results (Unavailable) | Cleared (Unavailable) | Data is retrieved to security level, attribution is calculated to security level, all data is displayed down to security level |
Display and Hiding the Total Row
All Performance analysis reports are displayed without the Total row. This makes the report more consistent with other OLAP reports. See the following figure.
You can choose to display the Total row using the Include TOTAL row in results option as shown in the following figure. Click Options from the second step of the report profile.
Note: | If you have an Advanced Report created prior to Release 9.0 that is based on a Performance Analysis report, hiding the Total row may cause the Advanced Report to fail. By default, any existing report created before Release 9.0 displays the Total row to avoid this issue. Only new Performance Analysis reports created in Release 9.0 or later have the Total row hidden by default. |
Set Report Thresholds for Entities and Time Periods
You can set report thresholds for Performance Analysis reports to control the number of entities and time periods used when running the report to provide a more manageable response time and to eliminate scenarios where reports run for unacceptable times and/or finish unsuccessfully. For example, you may want one report to run for hundreds of entities for any time period while intend another report to run for one entity for a maximum of one year.
If you run a report and exceed a report threshold, the report fails with an error message that identifies the threshold limit.
Note: | Be aware that the Performance System Parameter, Sys Item 28, Maximum number of entities in performance data fetch, is available as a system-wide parameter that can help to optimize overall report time. This parameter specifies the maximum number of entities allowed per query in the performance data fetch associated with the Performance Analysis report, along with other reports. It allows queries to run more predictably when you run the Performance Analysis report for complex queries, such as those used for Data Mart builds or on an ad hoc basis. For details, refer to the Performance System Parameters section of the Performance Calculation User Guide. |
To set report thresholds for a Performance Analysis report profile:
- Select the Create/Edit Performance Analysis report Step 2 dialog box, as described in "Creating a Performance Analysis Report Profile", and click Options.
The Report Options dialog box appears.
- Select the Set Report thresholds check box.
The Set Report thresholds dialog box appears. See the following figure.
- In the Entity thresholds field, specify the maximum number of entities for which to run the report.
The field displays a default value of 0 (zero), indicating an unlimited number of entities are acceptable. For LIST-type entities, the system enumerates the LIST-type entities before it applies the threshold. For composites, the system counts the entities and applies them towards the threshold before it enumerates them.
- In the Date range threshold in days field, specify the maximum of days for which to retrieve time series data when running the report.
The field displays a default value of 0 (zero), indicating an unlimited number of days are acceptable.
Override a Benchmark - Submit with Override
You can override benchmark assignments from the Submit with Override window. The override is created by specifying:
- A different benchmark
- Another benchmark assignment
Choose the Select the Benchmark tab on the Submit with Override window to initiate benchmark definitions. All valid benchmark definitions are displayed. You can either override the assignment, or, assign a specific entity. See the following figure.
This feature is used with all Performance Analysis reports like Perf Link Analysis, Risk Statistics, Equity Attribution, and Fixed Income Attribution.
Override a Benchmark - Advanced Report Override
The Advanced Report Override window provides a second technique for initiating Benchmark overrides. You can override either:
- The benchmark assignment
- A specific entity
Overrides are passed on to the underlying OLAP report.
Click the Select the Benchmark tab on the Advanced Report Override window to initiate benchmark definitions. See the following figure.
All valid benchmark definitions are displayed. You can either override the assignment, or, assign a specific entity. See the following figure.
Add Comment