...
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." |
Limit 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.
...
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 Hide 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.
...