Fun with MDX: Part 2-Product Contribution Ratio

In this installment of Fun with MDX we are going to put together a solution that will allow us to view the contribution ratio of internet sales for each level in the Adventure Works product hierarchy. This solution will look at two contexts for this ratio. The first ratio we will build is one that ignores the product hierarchy and shows the contribution ratio at the catalog or global level (i.e. Product vs All Products). The second ratio will highlight the product?s contribution within its parent (i.e. Mountain Bikes vs All Bikes).