I have a scenario and trying to think a way to get to a solution.
There is products fact table and customers dimension table.
The grain of fact table is 1 product per customer.
one customer can buy a product 'A' today and product 'B' tomorrow and so on.
I need to know the the count of customers who bought product 'A' and din't buy product 'B' and bought product 'C'.
How can I do such analysis? Is that a cube design implementation or MDX?
Any suggessions and help is greatly appreciated.
View Complete Post