Problem Note 58420: SAS® OLAP Server incorrectly sorts date values that have a Day format applied
The SAS OLAP server cannot correctly sort dimension levels that contain date values with a Day format applied. For example, date values with a format of DAY2. would not be sorted correctly.
The following display shows a SAS® Web Report Studio report built on a SAS OLAP cube where the Day Level has the DAY2. format applied. The report shows the following days for the fifth week of 2011:
January 31, February 1, February 2, February 3, February 4, February 5, February 6
Note: The order of the days is 1, 2, 3, 4, 5, 6, 31.
As a workaround, you can use a format that produces unique values across the Day Level. For example, you can apply the DATE7. format.
The following display shows the same cube but, in this case, the Day Level has the DATE7. format applied. The days of the week are now displayed in the correct date order:
January 31, February 1, February 2, February 3, February 4, February 5, February 6
Operating System and Release Information
SAS System | SAS OLAP Server | Tru64 UNIX | 9.2 | | 9.2 TS1M0 | |
Solaris for x64 | 9.2 | | 9.2 TS1M0 | |
Solaris | 9.2 | | 9.2 TS1M0 | |
OpenVMS on HP Integrity | 9.2 | | 9.2 TS1M0 | |
OpenVMS Alpha | 9.2 | | 9.2 TS1M0 | |
Linux for x64 | 9.2 | | 9.2 TS1M0 | |
Linux | 9.2 | | 9.2 TS1M0 | |
HP-UX IPF | 9.2 | | 9.2 TS1M0 | |
AIX | 9.2 | | 9.2 TS1M0 | |
HP-UX | 9.2 | | 9.2 TS1M0 | |
64-bit Enabled Solaris | 9.2 | | 9.2 TS1M0 | |
64-bit Enabled HP-UX | 9.2 | | 9.2 TS1M0 | |
64-bit Enabled AIX | 9.2 | | 9.2 TS1M0 | |
Windows Vista for x64 | 9.2 | | 9.2 TS1M0 | |
Windows Vista | 9.2 | | 9.2 TS1M0 | |
Microsoft Windows XP Professional | 9.2 | | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Standard Edition | 9.2 | | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 | | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 | | 9.2 TS1M0 | |
Microsoft® Windows® for x64 | 9.2 | | 9.2 TS1M0 | |
Microsoft Windows XP 64-bit Edition | 9.2 | | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 | | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 | | 9.2 TS1M0 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 | | 9.2 TS1M0 | |
z/OS | 9.2 | | 9.2 TS1M0 | |
*
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: | medium |
Date Modified: | 2016-06-24 15:01:25 |
Date Created: | 2016-06-16 12:43:03 |