Several different errors can be returned when a result set from a
drillthrough query is too large for the OLAP server to handle. When this
occurs, there are three routes to take to resolve the problem.

   1. Limit the number of returned rows using the MDX DRILLTHROUGH
      statement:

         DRILLTHROUGH maxrows 1000 firstrowset 5000
         select .... on columns,
                .... on rows
           from ....

      This will retrieve rows 5000-6000.

   2. Increase memory available to the OLAP Server.

   3. Set the Maximum Number of flattened Rows in the Advanced Options
      of the OLAP Server. You can access these options through SAS
      Management Console. You must have hotfix C9BA02 with SAS 9.1.2 to
      use this option.

Enterprise Guide 3.0 defaults to a MAXROWS setting of 2000 to limit the
size of the result set.

Operating System and Release Information