May 2002 MDX Puzzle

Many businesses use a type of analysis called dependency risk analysis. Challenge yourself to find the top 10 highest risk products, and show the percentage and amount of the products' sales that are at risk.

Russ Whitney

April 23, 2002

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A variety of businesses use a type of analysis called dependency risk analysis. This type of analysis determines whether one group of items in your business (e.g., products) is overly dependent on just one item of another group (e.g., customers). Retailers describe an overly dependent item as at risk. For example, you might want to find out which products depend most on a single customer. To answer this question, you need to find out what percentage of total store sales for each product comes from a single customer. Find the top 10 highest risk products, and show the percentage and amount of the product's sales that are at risk.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like