SQL Server Analysis Services Top N Plus All Other Rollup
User Rating: / 0
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?



Tags: mdx

Pyramid Analytics