Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

About Data Strategies

The data strategy governs the process of validating the vendor data, creating, enriching, and validating the golden copy security, and releasing the golden copy security on a field by field basis to the SECURITY database in the Eagle data warehouse.

When you create a data strategy, you select the options that control the types of reference data to release, the vendors to use, and the validations to apply for each gold copy composited security. You can define a series of data strategies for each reference data type, such as security, analytics, and so forth; however, you must not set up two data strategies that process the same security for the same reference data type. You can import Eagle default data strategies when you migrate security data strategies.


Each data strategy identifies the following:

  • Securities managed by the data strategy
  • Field groups and release levels in the data strategy
  • Gold copy sources to release
  • Source hierarchy rules for each field
  • Validation rules for each field
  • Enrichment rules for each field
  • Input values, such as default and override values

Create Data Strategies

Content on this page:

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.

Default Data Strategy

Once you create a data strategy, you can set it as the default data strategy. Each data category can have their own default data strategy. When a category has a default strategy set up, any securities that do not meet any other data strategy criteria are picked up and processed by the d default data strategy. This enables you to identify the securities that are not classified and to reclassify the securities appropriately.

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:

  1. In the Setup workspace, in the left navigation, click Data Strategies.
    You see the Data Strategy workspace with the list of available data strategies. Values include:
    - Analytics
    - Exchange Rate
    - Issuer
    - Issuer Analytics
    - Issuer Ratings
    - Prepayment Time Series
    - Price
    - Ratings
    - Relationships
    - Roles
    - Schedules
    - Security
    - Third Party Cash Flow
    - Variable Rates
  2. Click Create New and select the data type from the drop-down list.
    You see the Data Strategy Definition dialog box.
  3. In the ID text box, enter a unique identifier. If you leave this option blank, the system assigns a unique identifier.
  4. In the Name text box, enter a name for the data strategy.
  5. In the Description text box, optionally enter a description of the data strategy.
  6. Click the Source Rule drop down and select the source rules that govern the hierarchy of vendor data preferences.
  7. Click the Gold Copy drop-down and select a gold copy. Valid options are: Default, or All.  

  8. Click the Enabled check box (default) to indicate the data strategy is enabled for use. Or, clear the check box to disable use.
  9. To composite based on full schedule  Click Composite full schedule based on 1 vendor otherwise, the default is to composite based on each effective.
  10. To make this the default data strategy, check the box next to the Processing Option field.
  11. Click the Vendor Data Expiration drop down and optionally select a date rule to block stale vendor data from composite use.
  12. 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:

  1. 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.
  2. 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.
  3. Under Holdings Criteria, click to apply holdings criteria to this data strategy.
  4. Click the Entities drop -down and optionally select the entities to filter for securities with holdings processed by the data strategy.
  5. Click  the Source drop-down and select the source rule to apply to the data strategy.
  6. Click the Date Rule drop-down and select the date rule to apply.
  7. 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 /wiki/spaces/ReferenceData2017/pages/37931472 the composited security produced by the data strategy.

To select field groups for the data strategy:

  1. If compositing multiple gold copies, click the Gold Copy drop down and select the gold copy associated with this set of field group information.
  2. 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.
  3. 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
  4. 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:

  1. 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.
  2. Click the Release Level drop down and select the release level for each field as required.
  3. Set the Composite Null Values check box to indicate whether to allow the release of each field with a null value as required.
  4. Set the Authorization Needed check box for each field as required.
  5. Set the Log Changes check box for each field as required.
  6. 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:

  1. If compositing multiple gold copies, click the Gold Copy drop down and select the gold copy for this set of fields and source rules.
  2. For each field, click the Source Rule drop down and select a source rule to use, as required.
  3. 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:

  1. If compositing multiple gold copies, click the Gold Copy drop down and select the gold copy for this set of fields and validations.
  2. 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.
  3. 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:

  1. If compositing multiple gold copies, click the Gold Copy drop down and select the gold copy associated with this set of fields and overrides.
  2. 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.
  3. 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:

  1. In the Setup workspace, click Data Strategies in the left navigation.
    You see the Data Strategies workspace with the list of available strategies.
  2. 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.
  3. Select the historical record and click View Audit Record.
    You see the Data Strategy Audit Details dialog box.
  4. 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.
  5. 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:

  1.  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.
  2.  Select the data strategy you wish to submit and click Submit and Submit Data Strategy.
    You see the Submit dialog box.
  3.  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.
  4.  In the Days to Look Back text box, enter the number of days of recent vendor data you wish used for the composite.
  5.  Click the Effective Date drop down and select the date you wish securities composited.
  6.  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.
  7.  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:

  1. 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.
  2. 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.
  3. Click the Data Type drop down and select the data type you wish to composite.
  4. In the Days to Look Back text box, enter the number of days of recent vendor data you wish used for the composite.
  5. Click the Only Submit for Selected Securities and select the security/securities or Click the Only Submit for Selected Legal Entities and select the legal entity or entities to submit.
  6. 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.
  7. 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.
  • No labels