Why am I getting an error when drilling through to detail in an OLAP report?


Drill-through errors may be caused by one of the following scenarios:

The drill-through table is not available.
    The table specified as the drill-through source must be defined to the OLAP Server before it can be accessed by users. This can be done by assigning the appropriate library to the OLAP Server process. SAS Note 12215 details the steps required. Starting in SAS 9.2, security can also impact access to the drill through table. This is discussed in the SAS OnlineDoc. In addition to having the libraries defined, the OLAP Server user id, or the id used to start the server, must have read permission granted to the directories in which the tables are stored. This must be assigned through the operating system.
The columns are 255 characters or greater in length.
    Certain viewers currently require columns to be defined with a length of less than 255 characters. SAS Note 12467 provides more information. This issue is resolved starting with the SAS 9.2 release.
Columns are missing in the drill-through table.
    This situation will sometimes occur when the input table and drillthrough table are not the same source. If a column is included in the cube design, but is not present in the drill-through table, the subsetting performed during a drill-through may fail. If a column has been removed through security, as described above, the query should still complete, but the resulting table will not show the secured column.
Drill-through request returns a large number of observations.
    If the drill-through request size exceeds the available memory for the OLAP Server's drill-through allocation, the server will return an error. Details on this situation is documented in SAS Note 12151.

In all cases, the OLAP Server logs can potentially provide more insight as to the cause of the error. When contacting SAS Technical Support for assistance, please include a copy of both the error message from your viewer and the OLAP Server log. Instructions on retrieving additional logging in the OLAP Server can be found in SAS Note 36728 for SAS 9.2 and beyond.