Report Portal

SQL Server Analysis Services Top N Plus All Other Rollup

I recently used the SSAS TopCount feature to get the top 10 list of products within my products cube. How can I create a dynamic single rollup for the rest of the values, i.e. an All Other values, so that my total sales number is the true total and not just the top 10?

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.