AS 2005 Drillthrough records

In Analysis Services 2005, you can limit the number of records returned on a drillthrough action. It would be useful to be able to order the records before the number of records are truncated, how can you do this - in effect use an OrderBy function?

Any help is appreciated,
Dan

[298 byte] By [DanKitzmann] at [2008-2-15]

SQL Server

Site Classified