Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago

mapping based on whether or not a member already exists in the dimension

Originally posted by Patrick Victory Let's say we have ten thousand vendors in the source system. Most (~6k) of the vendors are minor and we don't need to maintain detail about them but we still ne...
Transformation
OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago
Originally posted by Jason Evans

A potential solution could be to use a parser business rule upon import.  In the rule, evaluate the vendor number against your dimension, if there's a match, then return the vendor number, if not, then either return "Other" or even "Other_<vendorID>.  If you did the Other<vendorID> approach, you would just use a mask rule to map Other* to Other which would provide the details needed for drill back.  Everything else would be * to *.