SQL Server Analysis Services Top N Plus All Other Rollup
User Rating: / 0
PoorBest 
Written by Scott Murray   
Wednesday, 19 March 2014 22:10

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
 

XL Cubed