...

The Report Sheet for Performance Calculation reports is a replica of your Performance Calculation results and is sorted and grouped the same way as the normal Performance Calculation report.

The first open cell in the Results worksheet contains the begin date and end date of the report period in an international date format. The security level results for all columns in the Report Sheet include hyperlinks. Clicking the security name link takes you to the Security worksheet for that security. See the following figure.

Image Modified

Anchor
_Toc521324245 _Toc521324245

Business Calendar Sheet

...

See the following figure.
Image Modified

...

The Commit Options section of the Parameters sheet shows the report's commit settings. You can assign commit options in the report profile. See "Defining the Performance Calculation Report Profile." You can also set commit options manually when you view report results and click the Commit the Profile icon. For more information, see "About the Client-Side Commit." See the following figure.
Image Modified
AnchorRTF380031003600360037003a00RTF380031003600360037003a00 Anchor_Toc337537747_Toc337537747 Anchor_Toc361231341_Toc361231341Parameters Sheet Example - Commit Options Section

Anchor
_Toc521324249 _Toc521324249

Rules

The Rules section of the Parameters sheet displays the rules used to run the report. This section includes one or more Report Rules, the Field Rule, and the Source Rule. For each Report Rule or Rules, Field Rule, and/or Source Rule defined in the report profile or applied as an override, this section indicates if that rule was not overridden or was applied using an override. See the following figure.
Image Modified
AnchorRTF350038003700330031003a00RTF350038003700330031003a00

Anchor
_

...

Toc521324250 _

...

Anchor_Toc521324250_Toc521324250Tolerance

Toc521324250

Tolerance Check Fields

The Tolerance Check section of the Parameters sheet displays the values that affect the tolerance checks applied when you ran the report. It includes the commit tolerance, the materiality check, and reference field names specified at the Field Rule or Report Rule level. For the Commit Tolerance Field, Materiality Check Field, and Numeric Reference Field, it also shows the corresponding database column name in the PERFORM database where this information resides. For more information about these fields, see "Using Tolerance Checks and Reference Fields." See the following figure.
Image Modified
AnchorRTF310035003200300031003a00RTF310035003200300031003a00 Anchor_Toc337537749_Toc337537749 Anchor_Toc361231343_Toc361231343Parameters Sheet Example - Tolerance Checks Section  

Anchor
_Toc521324251 _Toc521324251

Relation Fields

The Relation Fields section of the Parameters sheet displays the primary field and secondary fields with a Type of PC (Positions to Cash) stored in the Relation Fields table used in the report. You use this data when you calculate returns when a portfolio holds a position both long and short at the same time, and these positions are stored as two separate positions in the HOLDING database. These fields tell the performance return calculator how to join up positions and cash activity where there are optional columns such as long/short indicator that make up a virtual key. For more information, see "Chapter 5: Working with Long/Short Positions." See the following figure.
Image Removed
AnchorRTF330037003300330034003a00RTF330037003300330034003a00 Anchor_Toc337537750_Toc337537750 Anchor_Toc361231344_Toc361231344Parameters Sheet Example - Relation Fields Sectionfigure.
Image Added

Anchor
_Toc521324252 _Toc521324252

Errors

The Errors section of the Parameters sheet displays errors or warning issued during processing of the Performance Calculation report or during the committing of the data. See the following figure.
Image Modified
AnchorRTF310039003800380030003a00RTF310039003800380030003a00 Anchor_Toc337537751_Toc337537751 Anchor_Toc361231345_Toc361231345Parameters Sheet Example - Errors Section

Anchor
_Toc521324253 _Toc521324253

Commit Sheet

...

For more information, see "Configuring New Fields for Commit Mapping." See the following figure.
Image Removed
AnchorRTF340035003200350034003a00RTF340035003200350034003a00 Anchor_Toc337537752_Toc337537752 Anchor_Toc361231346_Toc361231346Commit Sheet Example - Commit Map Summary Section
Image Added

Anchor
_Toc521324256 _Toc521324256

Dictionary Detail Summary

...

This section includes the DICTIONARY_ID, DICTIONARY_ITEM_ID, DICTIONARY_DETAIL_ID, columns L1–L8 for each level of the performance model, all the PERF_SEC_RETURNS columns committed to and the values committed. Each level column, L1–L8, shows the level as well as the short and long description in parenthesis. This section does not describe security level data. For more information, see "Working with Dictionary Data." See the following figure.
Image Modified
AnchorRTF390037003700390030003a00RTF390037003700390030003a00 Anchor_Toc337537753_Toc337537753 Anchor_Toc361231347_Toc361231347Commit Sheet Example - Dictionary Detail Summary Section

Anchor
_Toc521324257 _Toc521324257

Entity Sheet

The Entity sheet for Performance Calculation reports displays all of the Entity fields that the report retrieved for processing. See the following figure.
Image Removed
AnchorRTF320030003700330034003a00RTF320030003700330034003a00 Anchor_Toc337537754_Toc337537754 Anchor_Toc361231348_Toc361231348Entity Sheet Examplefigure.
Image Added

Anchor
_Toc521324258 _Toc521324258

Security Sheet

...

If you ran the report for a composite, the Security sheet shows the securities associated with the composite's underlying entities. See the following figure.
Image Modified
AnchorRTF380032003600330035003a00RTF380032003600330035003a00 Anchor_Toc337537755_Toc337537755 Anchor_Toc361231349_Toc361231349Security Sheet Example

Anchor
_Toc521324259 _Toc521324259

Positions Sheet

...

The Positions section of the Positions sheet displays the positions used in processing the report. Each row has a column for each performance model level and a column for every begin date holdings field using in the processing of the report. Those columns retrieved for both the end effective date and begin effective date have one column for each date, with the field name pre-pended by the word "begin" or "end."
The rows in this section appear in order of Security Alias, followed by the Relation field used, such as the Long Short Indicator. You can click the Security Alias for each row to view that security in the Securities worksheet. See the following figure.
Image Modified
AnchorRTF370039003700330030003a00RTF370039003700330030003a00 Anchor_Toc337537757_Toc337537757 Anchor_Toc361231351_Toc361231351Positions Sheet Example - Positions Section

Anchor
_Toc521324262 _Toc521324262

Cash Activity Sheet

...

The Cash Activity Source section of the Cash Activity sheet shows the Cash Activity sources from the Source Rule used and the corresponding source instances. See the following figure.
Image Modified
AnchorRTF320039003200390039003a00RTF320039003200390039003a00 Anchor_Toc337537758_Toc337537758 Anchor_Toc361231352_Toc361231352Cash Activity Sheet Example - Cash Activity Source Section

Anchor
_Toc521324264 _Toc521324264

All Cash Activity

The All Cash Activity section of the Cash Activity sheet displays all the cash activity records used in processing the report. Each row has a column for each field used in processing the report, including flows and fields such as ORIG_TRANS_NUMB and PERF_FLOW_DESCR.
The rows in this section appear in order of Security Alias, followed by Effective Date, and then by Perf Flow Descriptor. You can click the Security Alias for each row to view that security in the Securities worksheet, where you can click another link for the security to jump to the Positions worksheet. See the following figure.
Image Removed
AnchorRTF330033003700350031003a00RTF330033003700350031003a00 Anchor_Toc337537759_Toc337537759 Anchor_Toc361231353_Toc361231353Cash Activity Sheet Example - All Cash Activity Section
Image Added

Anchor
_Toc521324265 _Toc521324265

SCF Sheet

...

The SCF section of the SCF sheet displays the SCF settings used if you enabled Significant Cash Flow (SCF) processing when you ran the report. For more information about the options in the report profile's Significant Cash Flow Processing dialog box, see "Chapter 4: Processing Significant Cash Flows (SCF)." See the following figure.
Image Modified
AnchorRTF360039003900370032003a00RTF360039003900370032003a00 Anchor_Toc337537760_Toc337537760 Anchor_Toc361231354_Toc361231354SCF Sheet Example - Report Parameters Section

Anchor
_Toc521324268 _Toc521324268

Inputs Section

The Inputs section of the SCF sheet displays any subperiod frequency performance data retrieved to complete the monthly frequency Performance Calculation report.

The Inputs section contains the columns: Group, Group Hierarchy, Rollup Returns ID, Security Alias, End Effective Date, Source, Frequency, Status (Preliminary or Final) and the input columns. Rolled up returns are first sorted by Rollup Returns ID, followed by Security level returns which are sorted by Security Alias.

...

See the following figure.
Image Modified
AnchorRTF390036003700390035003a00RTF390036003700390035003a00 Anchor_Toc337537761_Toc337537761 Anchor_Toc361231355_Toc361231355SCF Sheet Example - Inputs Section

Anchor
_Toc521324269 _Toc521324269

FX Rates Sheet

...

The Entity Base Currency section lists the entity type and Entity ID (in parenthesis) of each entity used in the report. This includes the profile composite, along with constituents and benchmarks. For each entity it displays the entity's base currency and an effective date. If you enable Entity History for the report profile, it shows the date when the base currency became effective for the entity. Otherwise, if you do not enable Entity History for the report profile, it shows the report effective date. The three columns to the right identify the type of FX conversion performed for the entity. See the following figure.
Image Modified
Anchor_Toc361231357_Toc361231357FX Rates Sheet – Entity Base Currency Section Example

Anchor
_Toc521324272 _Toc521324272

Inputs Section

The Inputs section displays all FX Rate data values used in the generation of the report results. FX Rates appear in order of From Security, To Security, and then Effective Date. See the following figure.
Image Modified
Anchor_Toc361231358_Toc361231358FX Rates Sheet – Inputs Section Example

Each line in this section provides information about an FX rate used in the report. The following table describes each column in this section.

...

The Field Parameters section of the Field sheet displays all the parameters for that field. See the following figure. These include the Begin Date and End Date of the data used, if the Use Business Calendar check is on, as well as the underlying performance fields and their database column name. The type of field you select and the options you select for that field determine the Field Parameters section's contents. For detailed information about setting up Performance Analysis, Performance Link Analysis, and Performance Risk Analysis fields, see the Performance Analysis and Reporting User Guide. See the following figure.
Image Modified
AnchorRTF310036003200300035003a00RTF310036003200300035003a00 Anchor_Toc337537763_Toc337537763 Anchor_Toc361231360_Toc361231360Field Sheet - Field Parameters Section Example

Anchor
_Toc521324276 _Toc521324276

Analysis Highlights Section

The Analysis Highlights section of the Field sheet displays the highest and lowest five values from all grouping levels, as well any null values for all the input fields. For the highest and lowest five values, the actual value displays while for the null values, the effective date displays. All the Highlights include links to the actual value within the Inputs section. See the following figure.

...

Image Modified
AnchorRTF330038003900310030003a00RTF330038003900310030003a00 Anchor_Toc337537764_Toc337537764 Anchor_Toc361231361_Toc361231361Field Sheet - Analysis Highlights Section

Anchor
_Toc521324277 _Toc521324277

Errors and Warnings Section

...

The Inputs section of the Field sheet displays all data values used in the generation of the report results. See the following figure. The Inputs section contains the columns: Group, Rollup Returns ID, Security Alias, End Effective Date, Source, Frequency, Status (Preliminary or Final) and the input columns (specified in the Field Parameters section in Figure 163). Rolled up returns are first sorted by Rollup Returns ID, followed by Security level returns which are sorted by Security Alias.

...

See the following figure.
Image Modified
AnchorRTF320030003200330033003a00RTF320030003200330033003a00 Anchor_Toc337537765_Toc337537765 Anchor_Toc361231362_Toc361231362Field Sheet - Inputs Section Example

Purge EagleEye Files

Your EagleEye files are stored in the customer attachments table in the PACE_MASTER database. Using the Data Archive Policy, you can purge built up EagleEye files or move them to another table.