Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

The following error may occur when applying a filter to a table or graph
using SAS Web Report Studio, SAS Web OLAP Viewer, or SAS Web Report
Viewer:

.sas.iquery.dataretrieval.QueryConnector -
An exception occurred while attempting to access data.
The following exception was thrown:
com.sas.iquery.dataretrieval.DataRetrievalException:
Exception occurred when retrieving the ResultSet.
[ com.sas.iquery.dataretrieval.DataRetrievalException:
Unable to execute query:Exception while executing MDX query.
[ com.sas.iquery.execution2.ExecutionException:
Exception while executing MDX query.
[ com.sas.storage.olap.OLAPException: An MDX syntax error occurred
[ com.sas.iom.SASIOMDefs.GenericError: An MDX syntax error occurred
[ com.sas.iom.SASIOMDefs.GenericError:
 Syntax error detected on line 1 at column 988.
Found ' SET [&&ROW&] as ',
expecting (, *, +, -, /, :, <, <=, <>, =, >, >=,
          AND, IS, OR, SELECT, XOR, ||.
]  ]  ]  ]  ]

The error is most likely to occur if you have a data item with an
unbalanced single quote, such as: "Men's Shoes".  To prevent the
problem, rename the data item, or apply the following hotfix:

Please note: This hotfix ONLY applies to SAS Web Report Studio 2.1,
SAS Web Report Viewer 2.1, and SAS Olap Viewer 2.1.

A fix for this issue is available at:

http://www.sas.com/techsup/download/hotfix/BIQ_913.html#014539

Operating System and Release Information

A fix for this issue for Business Intelligence Query and Reporting 9.1.3 is available at: