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 5 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.

If you have privileges, you can create a data strategy for the following security reference data types:

  •  Securities
  •  Analytics
  •  Ratings
  • Variable rates

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. From the Setup workspace, click Data Strategies in the left navigation.
    You see the Data Strategy workspace with the list of available data strategies. Values include:
    Analytics
    Issuer
    Issuer Analytics
    Issuer Ratings
    Prepayment Time Series
    Price
    Ratings
    Relationships
    Roles
    Security(No Contract/Legs or Contract/Multiple Legs)
    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. 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.
  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. Click the Default check box to set the data strategy as the default data strategy.
  10. Click the Vendor Data Expiration drop down and optionally select a date rule to block stale vendor data from composite use.
  11. 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.
    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)
  3. 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.
  4. Click the Entities drop down and optionally select the entities to filter for securities with holdings processed by the data strategy.
  5. Click Define for Holdings Criteria and optionally use the Logic Builder to define the securities with holdings processed by the data strategy.
  6. 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