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
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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
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 |