Hi Dave,

I am afraid that we cannot do it on the server side. When the client is
executing the MDX queries, it needs to do it itself.
304386 INF: MDX: How to Query for the 10 Best Customers and the Top 5
Products
http://support.microsoft.com/?id=304386

In addition, if you use OWC, you may filter a row or column field for top
or bottom n values or a percentage (Conditional filtering)

1. Select the field that has the values you want to filter.
2. Click Commands and Options on the PivotTable list toolbar, and then
click the Filter and Group tab.
3. Set Display the to Top or Bottom.
4. Set Items to a number in the list, or type the value you want.
5. To show n number of items, clear the % check box. To show n% of items,
select the % check box.
6. Set Based on to a value in the list.

The following article applies to drillthrough options.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8530


Bill Cheng

Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

This posting is provided "as is" with no warranties and confers no rights.
--------------------