In the Reference Data Center, you can use the Reports button on the ribbon to run reports. A full history is maintained for each data record in the application. Reports show all reference data and the associated audit information. You can sort columns alphabetically, remove columns, clear a filter on a column, use Find find to quickly identify items in a column, and freeze and unfreeze a column. You can use the Print or Export buttons on the ribbon to then print or export a report in an Excel or CSV file format.
...
About the Reference Data Reports
From the Reference Data Center, you can run the following reports:
Report Name | Description |
|---|---|
Data Strategy |
...
The Data Strategy |
...
report displays field level information on data strategies |
...
. You can filter the search results by data strategy. |
...
To run the Data Strategy report:
- From the Reference Desk workspace, click Securities in the left navigation.
You see the Securities workspace with all the available securities. - Click the View By drop down and select Security.
- Complete the required search criteria and click the Search button.
You see the search results based on the criteria you selected. - Select the security and click Reports.
You see the Reports dialog box. - Click Data Strategy and click OK.
- Click the Search button to display the results.
...
Exception Summary | The Exception Summary report displays all exceptions for a specified date. You can filter the search results by start and end date, error severity, security, error code and data category. |
Release Status Detail | The Release Status Detail report |
...
displays the current release status |
...
information at the individual security level |
...
. You can filter the search results by security, release status level, investment type, currency, data strategy, and gold copy. |
To run the Release Status Detail report:
- From the Reference Desk workspace, click Securities in the left navigation.
You see the Securities workspace with all the available securities. - Click the View By drop down and select Security.
- Complete the required search criteria and click the Search button.
You see the search results based on the criteria you selected. - Select the security and click Reports.
You see the Reports dialog box. - Click Release Status Detail Report and click OK.
- Complete the required search criteria and click the Search button to display the results.
...
Release Status Summary | The Release Status Summary report shows |
...
the total count of securities grouped by release status |
...
, gold copy and data strategy. |
...
You can filter the search results by |
...
effective date, gold copy, and data strategy. |
To run the Release Status Summary report:
- From the Reference Desk workspace, click Securities in the left navigation.
You see the Securities workspace with all the available securities. - Click the View By drop down and select Security.
- Complete the required search criteria and click the Search button.
You must specify an Effective Date. You see the search results based on the criteria you selected. - Select the security and click Reports.
You see the Reports dialog box. - Click Release Status Summary Report and click OK.
- Complete the required search criteria and click the Search button to display the results.
...
The Security Audit report shows all data changes. Information includes the source, security alias, ticker, primary asset identifier, investment type, issue name, security type, coupon, maturity date, processing security type, effective date, journal type, table name, column name, field name, new value, old value, master journal instance, last modified, action, and last updated by.
You can filter search results by journal instance, source, security, investment type, security type, processing security type, update user, journal type, update type, last hours, and field identifier.
To run the Security Audit report:
- From the Reference Desk workspace, click Securities in the left navigation.
You see the Securities workspace with all the available securities. - Click the View By drop down and select Security.
- Complete the required search criteria and click the Search button.
You must specify the Begin Date and End Date. You see the search results based on the criteria you selected. - Select the security and click Reports.
You see the Reports dialog box. - Click Security Audit Report and click OK.
- Complete the required search criteria and click the Search button to display the results.
...
User Audit Report
...
Securities not Assigned to a Data Strategy | The Securities not Assigned to a Data Strategy Report displays securities not associated with a data strategy. You can filter the search results by data strategy. |
Security Audit | The Security Audit report displays all data changes. You can filter the search results by data source, security, investment type, security type, processing security type, start date, end date, last updated by |
User Audit | The User Audit report displays the manual changes made to all securities and exceptions. You can filter the search results by security, action, investment type, and currency. |
Active Enrichments | The Active Enrichments report displays all enrichments that are currently assigned to data strategies and are enabled for the given data strategy. You can filter the search results by data strategy. |
Active Validations | The Validations report displays all validations that are currently assigned to data strategies and are enabled for the given data strategy. You can filter the search results by |
...
data strategy. |
Run Reports
Use this procedure to run all Reference Data Center reports.
To run the User Audit reporta report in Reference Data Center:
...
On the ribbon, click Reports and from the drop-down list, select the report you want to run.
You see the
...
Search panel associated with
...
the report you've selected.
Complete the required search criteria and
...
click Search
...
.
You see the
...
results
...
displayed in the panel below.
To print or export the report, click Export on the ribbon, and then select either Export to Excel or Export to CSV.