Problem Note 44707: "Unable to display detail data" in SAS® Web Report Studio if a filter has been defined with a member that contains a single quotation mark
 |  |  |  |  |
If you define a filter that references a member with a single quotation mark and that dimension is hidden in the table, then drilling to detail data might return an error similar to the following:
Unable to display detail data The immediate MDX execution failed -Formula error - An invalid member name was encountered in the MDX statement - near: "[Dim]..." -An MDX syntax error occurred
As a workaround, unhide the dimension and assign it to either rows or columns.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | Solaris for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Linux for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| HP-UX IPF | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows XP Professional | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows Vista for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows Vista | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Ultimate x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Professional x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Professional 32 bit | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Home Premium x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Enterprise x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| z/OS | 4.3 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 | ||
A fix for this issue for SAS Web Report Studio 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D26.html#44707A fix for this issue for SAS Web Report Viewer 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D27.html#44707A fix for this issue for SAS Web Report Studio 4.31_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G28.html#44707A fix for this issue for SAS Web Report Viewer 4.31_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G29.html#44707| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-10-26 09:46:00 |
| Date Created: | 2011-10-24 14:49:40 |