The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
OSAdmin
OneStream Employee
5 years agomapping 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...
OSAdmin
OneStream Employee
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 *.
Related Content
- 2 years ago
- 2 years ago
- 3 years ago