Configure Performance Queries

You can use Sys Item 28, a performance system parameter, to specify the maximum number of entities to include in each query of the performance data fetch. Eagle Performance uses the performance data fetch for:

• Performance Analysis report
• Performance Calculation report
• Composite Analysis report
• Composite Weighted Returns report
• Performance Composite Builder

If the performance data fetch identifies more than N entities in a query, it splits up the queries into an additional set. If the report includes benchmark relative fields, this setting applies to the number of portfolios; the query can include this number of portfolios plus any related benchmark entities.

This option promotes more predictable query execution for reports run as part of Data Mart builds or when you run the Performance Analysis report on an ad hoc basis. The default value is 100.

For more information, see the Performance System Parameters sections of Performance Calculation.