The Missing Portfolio Data report displays only portfolios (entity type of PORT) with missing performance and/or holdings data over the user defined date range or as of date. See the following figure. The report allows you to specify performance and holdings fields and search for NULL values for those fields for the selected portfolios. The report displays the Entity ID and Entity Name of portfolios that have missing data, along with the effective dates for NULL values for the selected performance and/or holdings fields, and restricts the results based on criteria specified in the Configure parameters. For each portfolio shown, it displays the effective date for any date in the date range where at least one field selected in the view is missing portfolio data, and indicates which fields are missing data for that effective date.
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.
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:
|
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 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.
Next, assume you are using report parameters similar to those shown in the following figure.
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.
The report compiles and displays the list of portfolios where at least one PERF_SUMMARY record is NULL for either eglPrf-GrossEndMktVal and/or eglPrf-GrossReturn for 8/31/2008 or 9/30/2008. The report does not include entities that have a Termination Date set prior to the date range selected in the report parameters.
0 Comments