When performing a drillthrough to detail data for your SAS OLAP cube that directly references a non-SAS database that does not follow SAS naming conventions, you may receive an error message similar to the following in your SAS OLAP Server log:

   <SASMessage severity="Error">
   The immediate MDX execution
   failed</SASMessage></Exception><Exception>
   <SASMessage severity="Note">
   select * from SAPEng./BIC/AZPAODSGL00 where ...
   </SASMessage>
   </Exception><Exception>
   <SASMessage severity="None">ERROR: SQL passthru  expression contained
   these errors: ERROR 22-322: Expecting a name....
   ERROR 76-322: Syntax  error, statement will be ignored....
   </SASMessage></Exception><Exception><...

The error occurs when a drillthrough is attempted on a SAS cube because the SAS OLAP Server is not correctly referencing the RDBMS table being used for drillthrough.

Some non-SAS databases have naming conventions that differ from SAS naming conventions. For example, a SAP BW table name such as /BIC/AZPAODSGL00 that is accessible via the SAS/Access to SAP BW LIBNAME engine, is not a proper SAS name when referenced explicitly. Therefore, when referenced in SAS, it needs to be referenced as follows:

To circumvent this error and allow the drillthrough to successfully execute, either rename the RDBMS table to follow SAS naming conventions or create a SAS view of the RDBMS table and use the SAS view as your drillthrough table. Once the modification is made, the OLAP cube would need to be recreated to reference the new RDBMS table name or SAS view.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :