I may be missing the forest for the trees (or even just not paying proper attention if I missed it), but is there a simple way to reference back to the original customer in my SSRS reports?
In other words, a v10-based Board of Directors report used to pull Mrs. Donna Bruni (customer_no = 105785), but on v11, it would instead pull Robert and Donna Bruni Household with a NULL for esal1_desc.
Conceptually, the original customer_no was pulled according to the query logic with all associated information based on that number. So, it makes sense that somehow I should be able to reference some kind of logic that holds the relationship information which essentially says "where you used to pull Donna Bruni as customer_no = 105785, you should now pull customer_no = 3031708", right? Is there possibly a new table that holds that?
Is this a dumb question? This is a dumb question, isn't it?
Thanks, Tessiturians.
Hi Matt -
Have you looked at using one of the three new customer views that helps pull affiliate/household info? Depending on how you want the data, I've found those are my goto views.
V_CUSTOMER_WITH_HOUSEHOLD
V_CUSTOMER_WITH_PRIMARY_GROUP
V_CUSTOMER_WITH_PRIMARY_AFFILIATES
- Heather
I don't know if the function MP_BUILD_SAL_V11 is of any use to you?
So maybe this is a dumb answer :)
oops yeah sorry probably is a dumb answer! but it's a useful SP!