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