MDX Tip of the Month - 01 Jun 1999

A common business problem is determining percentage contribution to a group. For example, you might want to know what percentage of the total revenue of a product line a particular product contributed, or what percentage of growth of sales in a country by each region in that country contributed.

Here's one way to solve this problem: For each revenue/dimension combination you want to analyze, create a new calculated member. For instance, if you want to analyze \[Store Sales\] as a percent of a group in the Product dimension, create a member as in Listing A. Screen A shows the result set from this query.