You can use the Setup workspace in Reference Data Center to create a data strategy by specifying information about the data strategy, including the name, general description, securities to process, fields to composite, data sources to use, and the enrichments and validations to apply during the securities compositing process. You can also audit the historical changes to data strategies.
Define the Data Strategy
You can define a data strategy that governs a specific subset of securities, including source hierarchy rules and other information about compositing data for these securities.
To define a new data strategy:
- From the Setup workspace, click Data Strategies in the left navigation.
You see the Data Strategy workspace with the list of available data strategies. - Click Create New.
You see the Data Strategy Definition dialog box. - In the ID text box, enter a unique identifier. If you leave this option blank, the system assigns a unique identifier.
- In the Name text box, enter a name for the data strategy.
- In the Description text box, optionally enter a description of the data strategy.
- Click the Data Type drop down and select the data strategy composite record type.
Options include:
– Security
– Analytics
– Ratings
– Variable Rates - Click the Source Rule drop down and select the source rules that govern the hierarchy of vendor data preferences.
- In the Additional Gold Copies check box, optionally check data sources to composite for additional gold copies.
NOTE: When you select this option, a warning message appears that you are resetting your customized settings for the data strategy. The setup of the data strategy requires the specification of the gold copy to use for holdings criteria, field releases, source hierarchy rules, validations, and override authorizations. - Set the Enabled check box (default) to indicate the data strategy is enabled for use. Or, clear the check box to disable use.
- Click the Vendor Data Expiration drop down and optionally select a date rule to block stale vendor data from composite use.
- Click Next.
You see the Data Strategies Securities dialog box.
Specify the Securities Criteria
You must specify the subset of securities governed by the data strategy.
To specify the selection of securities to use:
- Click Define for Security Selection Criteria and use the Logic Builder to define the security filter that defines the subset of securities processed by the data strategy.
- Click the Security Tab Configuration drop down and select the reference data you wish to composite or directly maintain for a security governed by the data strategy.
Composite reference data options include:
– Analytics
– Variable Rates
– Ratings
Direct maintenance reference data options include:
– Corporate Actions
– Final Factor
– Prepayment Time Series
– Schedule
– Underlying Securities
– Third Party Cash Flow
– Vendor History (view only) - Click the Gold Copy drop down and select the data source to filter for securities with holdings processed by the data strategy. To use this option you must define an additional gold copy when you define the data strategy.
- Click the Entities drop down and optionally select the entities to filter for securities with holdings processed by the data strategy.
- Click Define for Holdings Criteria and optionally use the Logic Builder to define the securities with holdings processed by the data strategy.
- Click Next.
You see the Data Strategy Field Group dialog box.
Select the Field Groups
You must select one or more field groups from the field groups you manage the composited security produced by the data strategy.
To select field groups for the data strategy:
- If compositing multiple gold copies, click the Gold Copy drop down and select the gold copy associated with this set of field group information.
- Click Select Field Groups drop down and select one or more field groups to define the composite produced by the data strategy.
You see the Field Group Selector dialog box. - Select one or more field groups and click OK.
You see the list of selected field groups in the Data Strategy Field Group dialog box - Click Next.
You see the Data Strategy Fields dialog box with the list of fields for each field group.
Assign Field Release Levels
You can re-assign release levels and override composite options for this data strategy. The assignments and options default to the field group definitions unless otherwise re-assigned and overridden.
To select release levels and composite options for fields:
- If compositing multiple gold copies, click the Gold Copy drop down and select the gold copy associated with this set of fields and release levels.
- Click the Release Level drop down and select the release level for each field as required.
- Set the Composite Null Values check box to indicate whether to allow the release of each field with a null value as required.
- Set the Authorization Needed check box for each field as required.
- Set the Log Changes check box for each field as required.
- Click Next.
You see the Data Strategy Sources dialog box.
Select Source Rules for Fields
You can select a source rule for each field to use when compositing data for the data strategy.
To select enrichment rules for fields:
- If compositing multiple gold copies, click the Gold Copy drop down and select the gold copy for this set of fields and source rules.
- For each field, click the Source Rule drop down and select a source rule to use, as required.
- Click Next.
You see the Data Strategy Validation dialog box.
Allow / Block Validations for Fields
You can allow and block field validations for fields when compositing data for the data strategy.
To allow or block validations for fields:
- If compositing multiple gold copies, click the Gold Copy drop down and select the gold copy for this set of fields and validations.
- Set the validation name check box to allow the use of this field validation. Or, clear the check box to block raising this validation flag.
- Click Next.
You see the Data Strategy Overrides dialog box.
Specify Overrides
You can specify the types of overrides allowed when compositing fields for the data strategy.
To specify the type of override allowed composite fields:
- If compositing multiple gold copies, click the Gold Copy drop down and select the gold copy associated with this set of fields and overrides.
- Click the Overrides drop down, and select the type of override. Options include:
– (Blank). No override applies.
– Override Value. Allows you to enter an override value.
– Default Value. Allows you to enter a default value. - Click Save to save the data strategy.
You see the refreshed list of data strategies in the Data Strategies workspace.
Audit Changes to Data Strategies
You can audit the historical changes to data strategies.
To audit changes to data strategies:
- In the Setup workspace, click Data Strategies in the left navigation.
You see the Data Strategies workspace with the list of available strategies. - Select the data strategy you wish to audit and click the Audit button.
You see the list of historical changes, including the user ID and timestamp associated with the change. - Select the historical record and click View Audit Record.
You see the Data Strategy Audit Details dialog box. - Click Compare Audit to Current to display the difference between the historical and the current field properties. Or, select a second historical record and click Compare Audit Records to display the differences between the two records.
- Click OK to exit the review.
Submit Data Strategies
You can use the Setup workspace in Reference Data Center to submit data strategies during quality assurance activities to confirm the setup of the strategy. You can manually submit a data strategy in a production environment to re-run a scheduled job. You can also submit the data strategies that govern a specific data type.
To submit data strategies:
- In the Setup workspace, click Data Strategies in the left navigation.You see the Data Strategy workspace with the list of all available data strategies.
- Select the data strategy you wish to submit and click Submit and Submit Data Strategy.
You see the Submit dialog box. - Set the Only submit for securities with changes since the last submission check box to restrict processing to only securities that have new data to composite.
- In the Days to Look Back text box, enter the number of days of recent vendor data you wish used for the composite.
- Click the Effective Date drop down and select the date you wish securities composited.
- Click the Gold Copies drop down and select the gold copy you wish composited.
- Set the Submit the Engine at Log Level check box to override the Default log levels and select a log level from 1 to 10.
- Click Submit. The data strategy is submitted to the system for compositing of the securities associated with the data strategy.
To submit data strategies governed by a specific data type:
- In the Setup workspace, click Data Strategies in the left navigation.
You see the Data Strategy workspace with the list of all available data strategies. - Select the data strategy you wish to submit and click Submit and Submit Data Type (Changes Only).
You see the Submit for Data Type dialog box. - Click the Data Type drop down and select the data type you wish to composite. Options include:
– Select All
– Security
– Analytics
– Ratings
– Variable Rates - In the Days to Look Back text box, enter the number of days of recent vendor data you wish used for the composite.
- Set the Submit the Engine at Log Level check box to override the Default log levels and select a log level from 1 to 10.
- Click Submit. All enabled data strategies for the specified data type are submitted for processing.
You can use the Monitor workspace in Reference Data Center, without exiting the Reference Data Center, to access the Automation Center for the status of submitted events with Process Type equal to Reference Data Center.
Add Comment