Usage Note 45910: Member order for SAS® OLAP cubes is ascending when parent totals are turned on in SAS® 9.3
Previous to SAS 9.3, the member order for SAS OLAP cubes displayed in clients would change from ascending order to descending order depending on whether parent totals were displayed on the top or on the bottom, respectively.
Figure 1 shows how the totals are displayed in SAS® Enterprise Guide® when the top view is selected. The members are displayed in ascending order.
Figure 1
Figure 2 shows how the totals are displayed when the bottom view is selected. The members are displayed in descending order.
Figure 2
In SAS 9.3, the member order is ascending regardless of the selected view. Figure 3 shows how the totals are displayed when the top view is selected. The members are displayed in ascending order.
Figure 3
Figure 4 shows how the totals are displayed when the bottom view is selected. Notice that the members are still displayed in ascending order.
Figure 4
Operating System and Release Information
| SAS System | SAS OLAP Server | Tru64 UNIX | 9.1 TS1M0 | 9.3 TS1M1 |
| OpenVMS Alpha | 9.1 TS1M0 | 9.3 TS1M1 |
| Linux | 9.1 TS1M0 | 9.3 TS1M1 |
| HP-UX IPF | 9.1 TS1M0 | 9.3 TS1M1 |
| 64-bit Enabled Solaris | 9.1 TS1M0 | 9.3 TS1M1 |
| 64-bit Enabled HP-UX | 9.1 TS1M0 | 9.3 TS1M1 |
| 64-bit Enabled AIX | 9.1 TS1M0 | 9.3 TS1M1 |
| Microsoft Windows XP Professional | 9.1 TS1M0 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.3 TS1M1 |
| Microsoft Windows NT Workstation | 9.1 TS1M0 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | |
| Microsoft Windows 2000 Server | 9.1 TS1M0 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M0 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M0 | 9.3 TS1M1 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.3 TS1M1 |
| z/OS | 9.1 TS1M0 | 9.3 TS1M1 |
*
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.
| Date Modified: | 2012-04-04 15:39:07 |
| Date Created: | 2012-03-05 14:59:07 |