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

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.

Content on this page:

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 the 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 and from the drop-down list, select the type of data strategy you want to create.
You see the Data Strategy wizard with the Define page as the default.
Depending on the type of data strategy you are creating, the wizard displays only relevant pages.
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.
The Data Type field defaults to the type of data strategy selected in from the drop-down list.
Select a Data Strategy Group from the drop-down list.
Select a Gold Copy from the drop-down list. See Options for more details.
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 Criteria page.

Specify the Security Criteria

In the Securities Criteria page you can define the security and/or holdings criteria.

To specify the security criteria:

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.
To apply holdings criteria to the data strategy, click the Apply holdings criteria to this data strategy check box and then select an option from the Entities, Source, and Date Rule drop-down lists.
To define Additional Criteria, click Define and optionally use the Logic Builder to define the securities with holdings processed by the data strategy.
Click Next.
You see the Sources page.

Select the Field Groups

In the Fields page you can select a field group that contains your intended composite field. RDC uses field groups which is the reason why a group is chosen even one there is only one composite field.

To select field groups for the data strategy:

Select the Field Groups from the drop-down list.
You see the field group details displayed in the space below.
Click Next.
You see the Fields page.

Select the Fields

In the Fields page you can define field attributes for the fields chosen in Field Group. See Options for more details.

For each field, select the check box that corresponds to the attributes you want to give the field.
Click Next.
You see the Sources page.

Define the Sources

In the Sources page you can select a pre-defined source hierarchy rule.

For each field that displays, select a rule from the Source Rule drop-down list.
You see the source hierarchy rules displayed in the space below.
Click Next.
You see Define Vendor Date Expiration page.

Define Vendor Data Expiration

In the Vendor Data Expiration page you can define the date rule for all vendor data sources. The Define Vendor Expiration page displays a list of the unique vendor sources of all the source rules used in the sources tab. By default it would be the vendor expiration rule selected or null if it’s not selected. User can override default rule for a particular source and save this as a DS override

For each Vendor Source listed, select the corresponding Date Rule from the drop-down list. Options include the vendor expiration rule selected on the Define page and Null.
Click Next.
You see the Enrichments page.

Apply Enrichments

In the Enrichments page you can select pre-configured enrichments to be applied to the data strategy that you are creating.

For each field that displays, select the Enrichment from the drop-down list.
Select if the enrichment to be applied is an Overlay or Default.
Click Next.
You see the Validations page.

Apply Validations

In the Validations page you can select which type of validation rules to apply to your data strategy.

Select the Validation Processing. Options include:
– Process using global validation rules only.
– Define specific validation rule
If you selected to Define specific validation rules, then select Validation Rule from the drop-down list.
Click Save & Close.
The data strategy has been added to the list of available data strategies in the workspace.

Apply Overrides

In the Override page you can apply field level overrides.

Select an option from the Override value drop-down list. Options include: Override Value and Default value.
Click Save & Close to save your sections.
Click Back to return to any of the previous pages where you can edit your selections.

Manage Data Strategies