New answers tagged business-intelligence
You could do that. I'm thinking something along the lines of having an active and inactive date on your fact table for each product for each customer. Then you could mark a previous product with an inactive date. This should allow you to query it for date ranges that are include a specific date to get what their product list was for a specific point in ...
If you have multiple product table for each customer then your you should write an Indexed View to get these figures instead of going into Fact Table. Even if you have a single table for products for customers, then you should go for an indexed view.
Top 50 recent answers are included