BottomCount, Filter and Null in SSAS2005 and ProClarity

One common business analytical problem is to find customers with low sales. In MDX we have the BottomCount function for that but compared to the TopCount function, that return the best customers,  BottomCount can return less clear results.

If you run this MDX Select in management studio, on the Adventure Works cube, you will see the 50 customers with least Internet Sales Amount in 2003 and what they have bought in 2004.  The MDX select is generated in ProClarity Professional 6.3 and I have used the filter functionality in the client.

Read more...

Also read Darren Gosbell reply.