Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Reporting in the Start Search text box.
  3. Click the General Reporting (Performance Center) link to access the Performance Center.
    You see the Performance Center with the General Reporting workspace.
  4. Click the Reports tab.
    The Reports Explorer appears.
  5. In the report categories area, expand the Reports folder, select the Performance Analysis folder, and click Compose.
  6. In the Building a new Report Profile pane, the system highlights Performance Analysis.
  7. 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.
  8. 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 ruleThe report rule to use for the report. For more information, refer to "Performance Analysis Report Rule" and the PACE Reporting Reference Guide.
    Analysis optionThis 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.
  1. 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.

  1. 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:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Reporting in the Start Search text box.
  3. Click the General Reporting (Performance Center) link to access the Performance Center.
    You see the Performance Center with the General Reporting workspace
  4. Click the Reports tab.
    The Reports Explorer appears.
  5. In the report categories area, expand the Reports folder, click the Performance Analysis folder, and identify the report you want to run.


  6. Right-click the report name, and select Submit with overrides from the shortcut menu. See the previous figure.
  7. 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.
  8. 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."

  1. 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.

  1. 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."

  1. 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."

  1. Click OK to submit the report.

Overide Link Periods in Underlying Fields

You can override field level linking periods at report run time by specifying different link periods in the Performance Analysis report profile. In the Performance Analysis report profile, you can specify the report effective date using two options specific to Eagle Performance:

  • Link Period Override
  • Link Period Override (Date Rules)

Link Period Override Option

The Link Period Override option allows you to specify any date to any date linking. The date range you select as the Link Period Override date period serves as the report effective date and overrides one or both of the dates specified in the report's underlying fields that use linking options, that is, reporting period options that define the dates used to link returns. This includes:

  • Performance Analysis fields
  • Performance IRR Analysis fields
  • Performance Link Analysis (PLA) fields
  • Performance Risk Analysis (PRA) fields
  • Performance Attribution fields
  • Global Attribution fields

Using this option is helpful when you periodically run similar reports, but run those reports for different time periods. You can include this option in the report profile itself, or can use this option on an ad hoc basis at run time when you use the Submit with Overrides option to submit the report. You can also use this option with Advanced Reports.
Selecting the Link Period Override Option
You can select Link Period Override from the report effective date options available when you create a Performance Analysis report profile. See the following figure. For more information, refer to "Creating a Performance Analysis Report Profile."

When you select the Link Period Override option as the date period for a Performance Analysis report profile, you can enter a date range as the Link Period Override. You can specify a start date and end date that differ, or can set the start and end date to the same date for a single day analysis. See the following figure.

Applying Dates with the Link Period Override
When you apply a Link Period Override to a report profile, the report applies the report profile dates to any linking fields configured with the Between dates option in the report Field Rule and overrides the field level hard coded dates. It processes all other types of linking fields and Performance Analysis fields by applying the report profile "To" date as the end effective date for the fields.
For Performance Link Analysis (PLA) and Performance Risk Analysis (PRA) fields, you can use the Link Period Override option to enter a start date and end date, and to override one or both of those dates in the field rule, depending on the type of linking period you specified at the field level. An example of these field level options appears in the following figure. For more information about these options, refer to "Performance Link Analysis Field Linking Options."

The following table describes the linking options you can specify for PLA and PRA fields and describes how Eagle Performance applies the Link Period Override dates you specify for the report profile.

PLA/PRA Field Level Linking Option

When Link Period Override applied at Report Profile

Use Prior Observations, Months, Quarters, Years

The field with the linking period uses the report profile's end date. The field calculates the appropriate begin date.

Between Two Dates

The field with the linking period uses both the report profile's begin date and end date.

Date Rule

The field with the linking period uses the report profile's end date. The field calculates the proper begin date according to the date rule parameters.

To-date returns

The field with the linking period uses the report profile's end date. The field calculates the appropriate begin date.


For attribution fields, you can use the Link Period Override option only to override linking periods entered through a fixed date date range to achieve "any date to any date" attribution. For more information, refer to the Attribution Guide.
Link Period Override Option Example
The following example illustrates how the system processes Performance Analysis (PA) and Performance Link Analysis (PLA) fields in a Performance Analysis report when you apply a Link Period Override at the report profile level.
The Performance Analysis report contains the following fields in its field rule.

Field

Name

Description

1

Beginning Market Value

Performance Link Analysis field configured using Daily frequency Begin Market Value Performance Analysis field and Link Option #2 – a custom defined link period (From 01/10/2003 To 01/17/2003).

2

Ending Market Value

Performance Analysis field configured using Daily frequency for Market Value.

3

Daily Return

Performance Analysis field configured using Daily frequency for Return.

4

Ad Hoc Return

Performance Link Analysis field configured using a Daily frequency Return Performance Analysis field and Link Option #2 – a custom defined link period (From 01/10/2003 To 01/17/2003).

5

Inception to Date Return

Performance Link Analysis field for Return using Link Option #4 – I want to Calculate Inception to Date.

6

Inception to Date as of Prior Day

Performance Link Analysis field for Return configured using a Date Rule.

The following table compares the linking periods you obtain during processing for these fields under two scenarios. In the first scenario, you submit the report with a report profile End Effective Date of 01/31/2003. In the second scenario, you submit the report with a report profile that includes a Link Period Override of 11/04/2002 to 12/13/2002.

Field

Name

Type

Field Description

Profile Report End Effective Date of 01/31/2003 Results in Linking Period

Link Period Override of 11/04/200212/13/2002 Results in Linking Period

1

Beginning Market Value

PLA

Uses Daily frequency Begin Market Value Performance Analysis field and custom defined link period (From 01/10/2003 To 01/17/2003).

Beginning Market Value as of 01/10/2003 (that is, Ending Market Value from 01/9/2003)

Beginning Market Value as of 11/4/2002 (that is, Ending Market Value from 11/01/2002)

2

Ending Market Value

PA

Uses Daily frequency for Market Value.

Ending Market Value as of 01/31/2003

Ending Market Value as of 12/13/2002

3

Daily Return

PA

Uses Daily frequency for Return.

One Day Return as of 01/31/2003

One Day Return as of 12/13/2002

4

Ad Hoc Return

PLA

Uses Daily frequency Return Performance Analysis field and custom defined link period (From 01/10/2003 – 01/17/2003).

Daily Linked Return for the Period From 01/10/2003 – 01/17/2003

Daily Linked Return for the Period From 11/4/2002 – 12/13/2002

5

Inception to Date Return

PLA

Uses I want to Calculate Inception to Date.

Inception to Date return as of 01/31/2003

Inception to Date return as of 12/13/2002

6

Inception to Date as of Prior Day

PLA

Uses Date Rule.

Inception to Date return as of 01/30/2003

Inception to Date return as of 12/12/2002

Using the Link Period Override Option in Advanced Reports
You can use the Link Period Override option with Advanced Reports for Performance Analysis. You do not select the Link Period Override option itself at the Advanced Report level, but can enter the dates used for the Link Period Override.
To use a Link Period Override with an Advanced Report for Performance Analysis:

  1. Create a Performance Analysis report profile with the Link Period Override option selected, with a related date range.
  2. When you create the Advanced Report Rule you plan to associate with the Advanced Report and are assigning Performance Analysis report profiles to that Rule, select the Force dates check box for the Performance Analysis Profiles associated with the Link Period Override.
  3. When you create the Advanced Report, in the Advanced Report Profile tab, where you can set advanced report profile settings, including advanced report rules, entities, and effective date, ensure you select the Between option as the effective date period and enter the date range you are using for the Link Period Override.

When you choose the Between dates option in the Advanced Report profile and input the From and To dates, the system passes those dates to the Performance Analysis report profiles that are part of the Advanced Report and processes the Link Period Override as it does for a Performance Analysis OLAP report.
For more information about setting up Advanced Reports, refer to the Advanced Reporting User Guide.
If you fail to perform these steps, the system processes the report as if you did not select the Link Period Override. It uses the Performance Analysis profile dates rather than the dates you input in the Advanced Report profile.

Using the Link Period Override (Date Rule) Option

When you select the Link Period Override (Date Rule) option as the date period for a Performance Analysis report profile, you can select a Date Rule to use as the Link Period Override.
The Link Period Override (Date Rule) option allows you to override linking periods entered using a fixed date date range or a date rule for:

  • Performance Analysis fields
  • Performance IRR Analysis fields
  • Performance Link Analysis (PLA) fields
  • Performance Risk Analysis (PRA) fields
  • Performance Attribution fields
  • Global Attribution fields

If you use fields with fixed date linking periods, the report profile uses the begin date and end date associated with the date rule in place of the fixed dates specified at the field level. It uses the date rule's end date as the "as of" date for the date rule.
If you use fields with date rules as linking periods, the report profile overrides the begin and end dates associated with field level date rule with the begin and end dates associated with the profile level date rule.
Using this option is helpful when you periodically run similar reports, but run those reports for different rolling time periods. You can use the same fixed date fields in each report, while using the Link Period Override with Date Rule option to change the time period for each report profile. You can include this option in the report profile itself, or can use this option on an ad hoc basis at run time by specifying them when you use the Submit with Overrides option to submit the report.
For example, assume you run three reports, a one-year rolling report, a three-year rolling report, and a five-year rolling report. These reports, which you run every month, contain different calculations and statistics. If you do not use this option, you build each field three times, one for each time period, and then build the reports by assigning those the field that corresponds with the time period of that report. However, if you use this option, you can build the field once as a fixed date field and use that field in all three reports. Then, by using Linked Period Override (Date Rule) at the profile level, you can apply the rolling time period date rules to override these fixed date fields.

Note:

If you choose the Link Period Override (Date Rule) option and use it to select an Inception to Date or a Fiscal Year to day type date rule, be sure to only use the report profile with a single entity. Otherwise, if you use the option with multiple entities, the report applies the first entity's inception date (or fiscal date) to all entities in the report profile.



Selecting the Link Period Override (Date Rule) Option
You can select Link Period Override (Date Rule) from the report effective date options available when you create a Performance Analysis report profile. See the following figure.

When you select the Link Period Override (Date Rule) option, you can enter a date rule as the Link Period Override. See the following figure.

Using the Link Period Override Option in Advanced Reports
You can use the Link Period Override (Date Rule) option with Advanced Reports for Performance Analysis. You do not select the Link Period Override (Date Rule) option itself at the Advanced Report level, but can enter an as-of date used for the Link Period Override (Date Rule).
To use a Link Period Override (Date Rule) with an Advanced Report for Performance Analysis:

  1. Create a Performance Analysis report profile with the Link Period Override (Date Rule) option selected, and a related Date Rule specified.
  2. When you create the Advanced Report Rule you plan to associate with the Advanced Report and are assigning Performance Analysis report profile to that Rule, select the Force dates check box for the Performance Analysis Profile associated with the Link Period Override (Date Rule).
  3. When you create the Advanced Report, in the Advanced Report Profile tab, where you can set advanced report profile settings, including advanced report rules, entities, and effective date, select the As of option as the effective date period and enter the corresponding as-of date you are using for the Link Period Override (Date Rule).

When you choose the As of option in the Advanced Report profile and input the as-of date, the system passes that date to the Performance Analysis report profiles that are part of the Advanced Report and processes the Link Period Override (Date Rule) as it does for a Performance Analysis OLAP report.
For example, you specify February 15, 2011 as the Advanced Report's as-of date, and your Performance Analysis report includes a Link Period Override (Date Rule) where the Date Rule is Month to Date. In this case, the report calculates a month to date as of February 15, 2011, and uses that period to override the field-level dates associated with the report.
For more information about setting up Advanced Reports, refer to the Advanced Reporting User Guide.
If you fail to perform these steps, the system processes the report as if you did not select the Link Period Override (Date Rule). It uses the Performance Analysis profile dates rather than the date you input in the Advanced Report profile.

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.
By default, the field displays a value of Total. You must select a level other than Total for a meaningful attribution analysis.

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:

  • Do not limit results. (Default) Displays all results.
  • Limit results. Displays report results down to the level specified in the prior field in this section. Does not retrieve security level data so that it can roll up that data.

    This is the most optimized option, resulting in the fastest report run time. The system processes records for Performance Analysis, Performance Link Analysis, and Risk Statistic field types only down to the same limit level used for the Attribution fields. Selecting this value can result in the processing of many less records and correspondingly faster report run times. However, this option does lead to the limitation that any security level and entity rollup fields included on the report show as blank due to the lack of record processing below the limit level.
  • Limit results, fetch and display securities. Displays report results down to the level specified in the prior field in this section. In addition, retrieves and displays security level data below the selected level. This option allows you to view securities below a performance model level when that level is not the lowest level in the model.
  • The system retrieves records and processes them down to the security level for Performance Analysis, Performance Link Analysis, Performance Risk Analysis, Performance IRR Analysis, Performance Attribution Group, and Global Attribution Group fields even though the report level is limited above the security level.
  • Limit results, fetch but do not display securities. (This option is provided for backward compatibility only.) Displays report results down to the level specified in the prior field in this section, the Selected level to calculate attribution and display results down to field. Does not display security level data, but retrieves security level data so that it can roll up that data.

    The system retrieves records and processes them down to the security level for Performance Analysis, Performance Link Analysis, and Risk Statistic fields even though the report level is limited to above the security level. The chief benefit of this option is that it allows you to display security and entity fields in rollup fields on Performance Analysis reports.
    Some examples of report results you receive after selecting these options appear in the next section.

Show attribution inputs below selected level

For attribution reports, do one of the following:

  • Select this check box to display the attribution input weights and returns below the level selected for the calculation of attribution statistics in the Selected level to calculate attribution and display results down to field.
  • Clear the check box to prevent display of the attribution inputs below the selected level.

    By default, if you set the Limit results to the level selected above field to:
  • Do not limit results, this check box is selected.
  • Limit results, this check box is cleared and unavailable.
  • Limit results, fetch and display securities, this check box is selected and unavailable.
  • Limit results, fetch but do not display securities, this check box is cleared and unavailable.

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:

  1. 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.

  1. Select the Set Report thresholds check box.

The Set Report thresholds dialog box appears. See the following figure.

  1. 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.

  1. 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.

Create Multilingual Report Results

You can use Eagle's multilingual reporting capabilities to generate Performance Analysis report results in languages other than English. The Performance Analysis report can include multilingual security field attributes such as security name, entity field attributes such as portfolio name, and performance model information such as GICS sector.
For example, with the appropriate setup, you can generate a Performance Analysis report that displays portfolio names, security names, and GICS sectors in French or in Japanese.

Loading Data in Multiple Languages

If you plan to create report output in languages other than English, you must load the appropriate multilingual data (in addition to the general financial information and performance related data, such as returns and index data, as described in the Performance Calculation User Guide and Benchmark Management User Guide) before you run the report. You can load multilingual data that can display in the report for:

  • Security Field Attributes. For example, issue name, investment type.
  • Entity Field Attributes. For example, entity name for portfolio, manager name, benchmark name.
  • Code Translations for Performance Model Nodes. You can store Code Values that provide translations for the nodes used in performance models to group report data. For example, names of sectors, industry groups, industries, countries.

Be aware that the translations for the multilingual data are not shipped with the Eagle product.
When you store multilingual data for security and entity attributes, you typically provide data that supplements the English data already present in the database. For example, you store the security with an issue name of Ford Motor Company and you additionally store the Japanese translation for the issue name, "Ford Motor Company." Eagle allows you to store "local only" multilingual security or entity data for which there is no corresponding English translation. In that case, you store a null value in the table that stores the English data. However, Eagle does not recommend that you use "local language only" type data in the Performance Analysis report.

Using the Performance Calculation Report

Using the Performance Analysis report to generate non-English results has no impact on the way you set up and run the Performance Calculation report. You use the Performance Calculation report to run and commit results in English. The Performance Model commits to the RULES database DICTIONARY_DETAIL table in English.

Selecting a Language for the Performance Analysis Report

After you set up Eagle to support languages other than English, you can specify a language to use for the report output in the report profile criteria. You can do so when you create/edit the report profile or when you submit the report with overrides. For details, refer to "Creating a Performance Analysis Report Profile" and "Running the Performance Analysis Report on an Ad Hoc Basis."
For general information about generating OLAP report results in multiple languages, refer to the PACE Reporting Reference Guide.

Performance Analysis Report Multilingual Information

The Performance Analysis report can display multilingual data for the following types of report elements:

  • Security Field Attributes. The report can display multilingual data for Security field attributes used in the report's Field Rule or Grouping Rule (if you run the report in dynamic mode). The report can use data stored in a database column or a Code Value in another language.
  • Entity Field Attributes. The report can display multilingual data for Entity field attributes used in the report's Field Rule or Grouping Rule. The report can use data stored in a database column or a Code Value in another language.
  • Code Translations for Performance Model Notes. The report can display multilingual data for the performance model selected for the report. The Performance Analysis report uses performance models specified using Grouping Rules. The report can use data stored for nodes as a Code Value in another language.

Two report samples follow.
The following figure shows an example of a Performance Analysis report in French. Note that the fund names, the security names, and data in the two columns on the right side of the report appear in French. In this example, the report's Grouping Fields do not utilize multi-lingual code values. For example, the FIN grouping has subgroupings of INS and BANK. The TRAN grouping has subgroupings of AUTO and AIR.

The following figure shows another example of a Performance Analysis report in French. For this report, the fund names, the security names, and data in the two columns on the right side of the report also appear in French. In this example, however, the report's Grouping Fields do utilize multi-lingual code values. For example, the Financiers grouping has subgroupings of Les Assureurs and Banque. The Transports grouping has subgroupings of Compagnies Aériennes and Véhicules.

Enabling Multilingual Benchmark Names

Performance Analysis fields can store benchmark names in more than one language, and then display the benchmark name on the report in the language selected for the report. To do this, from the Effect drop-down list, select Index Name. Next, click Field Options, and from the Change Field Type drop-down list, select Wide Character. See the following figure.

Other Considerations

If you use Eagle Data Mart to track Performance data generated by the Performance Analysis report, you can use Data Mart to store selected information in languages in addition to English. Additional Data Mart setup, such as the creation of a separate Data Mart instance per language, may be necessary. For more information, refer to the Data Mart User Guide.
If you set up Eagle's Portal so that Portal users can view Performance Analysis report results, and/or run Performance Analysis reports based on their own run time criteria, be aware that Eagle's Portal platform can display text data fields stored in languages other than English. With the appropriate setup and translated data loaded, Portal users can view Portal elements such as search strings, query, and dashboard names in other languages. While Portal supports the ability to translate the entire user interface into languages other than English, the translations themselves are not shipped with the Eagle product.

  • No labels