Maxrows in Drillthrough

Even when I set the maxrows in my drilltrough action to 2500, the data sample viewer still states that 1000 records were sampled.

Is this 1) a limitation of the viewer (ie - I would see all of my rows if I used a different application to view the data)

or 2) A limitation of SSAS - no more than 1000 rows will ever be returned

or 3) Something that the interface has hard coded into the screen that does not reflect what is actually happening.

Thanks for the help.

Ann

It definitely isn't: "(2) A limitation of SSAS - no more than 1000 rows will ever be returned". If you execute this drillthrough query on Adventure Works in Management Studio, 1899 rows are returned - adding "maxrows 1500" limits output to 1500 rows:

Drillthrough

select {[Measures].[Reseller Order Quantity]} on 0,

[Product].[Product Categories].[Subcategory].&[17] on 1

from [Adventure Works]