Market Basket Analysis in SSAS 2005+

This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services). Market Basket Analysis answers this question of this kind: "Customers who bought product A also bought product B." This article assumes some prior knowledge of SSAS and MDX. Here is what we want the result set to look like: