SSAS clients and TopCount

Last week I met an end user that struggled with building a simple TopCount report in ProClarity. At the first look I thought it would be a simple problem that the client should handle with standard functionality, but that was not true. The end user requested a report with the top ten symptoms and all the related detailed symptoms to each top 10 item.

We can easily build the same scenario with the Adventure Works cube. Give me the top 10 customers in 2004 according to Internet Sales Amount and show me all the products they have bought. In ProClarity you would place customers and products on the rows and Internet Sales Amount and the Calendar Year 2004 on columns. You then expand the customers and products dimensions to their leaf levels and put a TopCount 10 filter on that. I will start with the top ten customers for 2004.