Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The report includes columns for Entity ID, Entity Name, and each specified performance and/or holdings field. For general information about running and using the report, see Use the Composite Monitor.

Missing Portfolio Data ReportImage Modified
The following table describes the report parameters you can select.

Option

Description

Date Range

You can submit the report for a user defined date range. Options include:

  • Between.

 This
  •  This option allows you to determine if any NULL records exist for any date (either monthly or daily) for the portfolio within the date range.

  • From the Date Rule.

 You
  •  You can further customize the date by using a Date Range rule.

Entities

The Entity Selector allows you to run the report for specific portfolios, a list of portfolios, or all portfolios (by leaving the selector empty). This applies to entities with a type of PORT or portfolio equivalent.

Fields

You must use the Field Selection dialog box to add one or more fields as report columns. You can change the order of report columns. 
The report can include performance and holdings fields for the selected composites. The Field Selection dialog box identifies default fields with a blue field icon.


The following example demonstrates how the report uses the Configure settings in combination with the report parameters to generate the report results. Assume that you use the Configure link to define the Composite Monitor configuration settings shown in the following figure.

Configure Dialog Box - Missing Portfolio Data Report ExampleImage Modified
Next, assume you are using report parameters similar to those shown in the following figure.

Missing Portfolio Data Report - Report Parameters ExampleImage Modified
Because you left the Entities report parameter empty, the query searches under the JK Source Rule Source and the eglPrfPc-Total Level Model Performance Model for any NULL values with a Monthly Frequency in the Preliminary Performance Status stored in the database for eglPrf-GrossEndMktVal and/or eglPrf-GrossReturn for any month between 8/31/2008 - 9/30/2008.

...