Rows limited to 10,000 on drillthrough?

Nov 17, 2010 at 3:30 PM

i am using ExecuteDrillthroughAndFixColumns in conjunction wtih GetCustomDrillthroughMDX and i notice that the drillthrough returns only 10,000 rows. The default drillthrough returns the full 42000+ rows. Is there anything I can do to modify this restriction on rows retruned?

Nov 17, 2010 at 6:07 PM
Edited Nov 17, 2010 at 6:08 PM

Are you passing in 3 parameters to the GetCustomDrillthroughMDX function? Something like the following should work:

    "[Internet Sales].[Internet Sales Amount]
    ,[Internet Sales].[Internet Total Product Cost]
    ,NAME([$Source Currency].[Source Currency Code])"

Or you can connect to SSAS in Management Studio, right click on the server node, and choose Properties, click Advanced, and then change OLAP \ Query \ DefaultDrillthroughMaxRows

Nov 18, 2010 at 11:27 AM

I was not passing in a third parameter only the first - the list of rows to return.

Apologies for not reading the function notes fully before posting. Having just reread them I can see that this is fully explained.