Creating ranking metrics

Now we know Touring-1000 Yellow is to blame; but there are also other underperforming products (so to speak). The bikes Product Manager and the Sales Manager are very curious to know the 10 less profitable products in our shop, in order to review the catalog, and come up with a creative way to cover losses. You are tasked with the "10 most money-losing products of all time" report. How would you do it? Well, yes, sort them and print just the first 10 lines could be an easy fix; but there's a more elegant solution. Use the Rank function.

Getting ready

My opinion is that in BI there is not only one "single" solution to reporting requests. Everyone has his/her preferences, we can get to the same results from different path ...

Get Business Intelligence with MicroStrategy Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.