After going through all available posts, unfortunately I could not find a solution for my problem. I have to create a dynamic named set of with TopCount in a cube that will be accessed with excel 2007. This how the outcome should look like:
Grand Total $300.00
This is the MDX I used which gives me the top 3 but not the "Others" and the "Grand Total." Just to keep it simple I used top 3 Brands.
CREATE DYNAMIC SET CURRENTCUBE.[Top 3 Brands]
, DISPLAY_FOLDER = 'Sets';
Now I am stuck here. After reviewing many posts it seems that Excel 2007 has some issues with handling sets. I found two possible solutions from Raymond-Lee which I think may work.
Solution 1 - Use a named query in dsv
Solution 2 - create a dummy "Others"
Here is the post:
View Complete Post