Hi all.

I use Analysis Services 2000. In my cube I have Sales fact and some
ProductDimension. I need to calculate Add-Onn Sales for every product.

Add-on sale is amount of money spent for other products when buying some
products together, for example:
Coca-Cola 1$
Hot-Dog 2$
French Fries 1.50$
Add-on Sale for Coke will be 3.50$, for Fries - 3$ and for Hot-Dog - 2.50$

My question is how can I calculate Add-On Sales for every Product in my
cube? Every Sales transaction has unique Date & Shop Id, every Product has
it's unique Id.