Creating TOP X queries with SSAS 2008

Once you start working with BI, one of the most popular requests is “Can you create a TOP 5 Products report”? So let’s see how SSAS 2008 can help us with that. There are different ways to create TOP X queries/reports with SSAS.

The way I prefer is creating a new Named Set. So let’s create a TOP 5 Products (I am using the Adventure Works DW 2008 SE sample database). On the Calculations tab of the Cube Designer window click on New Named Set button.