BODS 3.2 Dictionary Alias Not Working

35 Views

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