Problem Note 37835: SAS® OLAP cubes with an all member that uses a level name might cause client applications to work incorrectly
 |  |  |  |  |
If a hierarchy is defined in an OLAP cube with the ALL_MEMBER= option set to "All" or any other level name in the hierarchy, client applications such as SAS® Web Report Studio and SAS® OLAP Cube Studio might not function correctly. Exporting a report from SAS Web Report Studio into the SAS® Add-In for Microsoft Office, or expanding items in a filter are some examples of the functions impacted by this issue.
One possible workaround is to use a name other than a level name for your all member. The string you choose is arbitrary, as long as it contains something more than just a level name. For example, the default value for a hierarchy's all member name is a suitable option. This default string is "All <Hierarchy Name>".
CAUTION: Changing this string in an existing cube might require changes in your information maps and reports.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Server | z/OS | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.2 TS2M3 | ||
| HP-UX IPF | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Linux | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Linux for x64 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| OpenVMS on HP Integrity | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Solaris for x64 | 9.2 TS2M0 | 9.2 TS2M3 | ||
A fix for this issue for Base SAS 9.21_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A50.html#37835A fix for this issue for SAS Web Report Studio 4.2_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A55.html#37835A fix for this issue for SAS Web Report Viewer 4.2_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A62.html#37835| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> Cubes Query and Reporting |
| Date Modified: | 2009-11-18 10:57:17 |
| Date Created: | 2009-11-16 10:42:54 |