BODS 3.2 Dictionary Alias Not Working

[brad_schroeter2]

From what I understand, here are the dictionary pieces and values for a firm example:

-Primary is what DS searches for in firm to do a replacement; value is "SUPER CENTER"

-Standard is what DS changes the firm to; value is "Spr Ctr"

-Aliases is alternate forms of what DS searches for in firm to do a replacement; value is "SS, SUPERCENTER"

When I run a job which has a data cleanse step referencing the dictionary, here are the following scenarios:

1. Entered = SPR CTR; returned = SPR CTR (makes sense)

2. Entered = SUPER CENTER; returned = SPR CTR (makes sense)

3. Entered = SS; returned = SS (doesn’t make sense since I'm expecting "SPR CTR" to be returned)

4. Entered = SUPERCENTER; returned = SUPERCENTER (doesn’t make sense since I'm expecting "SPR CTR" to be returned)

Is my understanding of the dictionary pieces correct and if yes, why aren't the Standards returned in #'s 3/4 above when I enter the Aliases?

Thanks,

Brad

[former_member213714 · Accepted solution]

Hi Brad,

The alias information entered for the primary will be output from the Data Cleanse transform in the Match Standard fields (e.g. FIRM1_FIRM_MATCH_STD1). This match standard information can then be used in a downstream Match transform to allow for records to match where one might have a firm of 'SUPER CENTER' and the other 'SPR CTR' as long as the primary for 'SUPER CENTER' has an alias of 'SPR CTR'.

To have SS be output to your firm field as 'SPR CTR' you will need to add a primary of SS and give it a firm standard of 'SPR CTR'. Any word that you want to be converted would need to exist as a primary entry in the dictionary with the standard you want it converted to. Hope this helps.

Doug Staub

[brad_schroeter2 · Accepted solution]

Doug,

I appreciate the explanation on how the dictionary alias can be used in a downstream match transform.

Could you explain to me how in the match transform for a criteria field that you want it to use both the data cleanse standard ("Spr Ctr") and the data cleanse alias ("SS") against candidate records which have firm = "Spr Ctr" or "SS"?

Thanks,

Brad

[former_member213714 · Accepted solution]

Brad,

To use the match standards in the Match transform you would simply output from the upstream Data Cleanse both the Firm output field as well as the Firm Match Standard output fields you want to be considered in the match. These fields would then all be mapped as input fields in the Match transform. When setting up your Firm rule in the match criteria you would map those fields. See the screenshot for what the criteria looks like in the Match transform.

in this screenhot only the Firm and its first 3 match standards were output from Data Cleanse and input to Match so only those fields are available to be mapped here. When comparing records, Match will use all of these firm fields when matching records.

You may also want to take a look at the following Knowledge Base article that details the same thing, it just uses name data as the example rather than firm.

https://service.sap.com/sap/support/notes/1477449

I hope this helps.

Doug