In my Products Sales re****t I had all products sales as belonging to
the "Unknown" product category.
Searching in this newsgroup I've found a message suggesting that this
was due to the fact that the product_catalog_base column in the
OrderFormLineItems of the transaction database was null and updating
it with the value from the product_catalog column will fix the
problem. Indeed it works, now all my product sales belong to a specifc
category, however I haven't found a single piece of do***ent from MS
that explains why this happens and best practices to solve the issue.
What I end up doing was executing the following query just before
running the Datawarehouse Im****t DTS task:
update mscs_transactions.dbo.OrderFormLineItems
set product_catalog_base = product_catalog
where product_catalog_base is null
Anybody with better ideas or references to MS docs?
Thanks,
Alex
