Interactive sort and MDX queries

HI
When i fill the details row of a Table as Eg. Sales value and Product Name and give Interactive Sort on both the columns , the functionality seem to work correctly if the DataSet is filled using an SP but when i do it with MDX query, it doesnt happen. Any ideas?

regards

Sai

[298 byte] By [Saishyam] at [2007-12-25]

SQL Server

Site Classified