I am using the Excel 2007 Pivot Table "Show Details" functionality and find it limited to 1000 rows.
I thought I might be able to increase that by creating a default drill-through action in my SSAS Cube but, although the columns displayed are changed according to my drill through definition, the row limit to 1000 remains.
On the other hand, if I use "Additional Actions / My Drillthrough Action" in the right click menu, instead of "Show Details", I get the columns I defined but this time it is limited by the maximum rows I specified in "My Drillthrough Action".
Of course, I can instruct my users to use "Additional Actions / My Drillthrough Action" instead of "Show Details" but it would be nice if they did not have to!
Is it possible to overrule this 1000 rows limit?
My server is SQL 2008 Enterprise 64 bits SP2