This project has moved and is read-only. For the latest updates, please go here.

Rows limited to 10,000 on drillthrough?

Nov 17, 2010 at 4: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 7:07 PM
Edited Nov 17, 2010 at 7:08 PM

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

ASSP.GetCustomDrillthroughMDX(
    "[Internet Sales].[Internet Sales Amount]
    ,[Internet Sales].[Internet Total Product Cost]
    ,NAME([$Date].[Date])
    ,NAME([$Customer].[Customer])
    ,NAME([$Product].[Product])
    ,NAME([$Promotion].[Promotion])
    ,NAME([$Source Currency].[Source Currency Code])"
   ,([Measures].CurrentMember)
   ,50000
   )


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 12:27 PM

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.