Report Portal

Calculating Percentile in SQL Server Analysis Services MDX

In many organizations like the financial and health sector, knowing a average (mean) number isn’t enough. They also want to know a ranking of the salespeople, patients or products with their percentile. In other words, how does your Germany branch stack up to its peer branches? The result, I’d be after is something like the following in Analysis Services:

Read more...

Tags: mdx, non empty

 

2007-2015 VidasSoft Systems Inc.