Usage Note 14452: Using the GROUP BY and SORT BY functions of the SAS Human Capital
Management query filter may cause problems
Within the Query tool of SAS Human Capital Management 3.1 (HCM, HRV, HR
Vision), the user may experience the values in the Add Filters page
being corrupted when a query created in version 3.1.0.2 or 3.1.0.3 is
utilized in 3.1.0.4.
The query exhibits the problem when the 'group by' and
'sort by' functionality are both used. A new query in 3.1.0.4 with a
group by and order by clause looks like:
GROUP BY EMPSTAT, EEOCLASS, GENDER ORDER BY AGE ASC, GENDER ASC
But a new query created in 3.1.0.2 looks like:
GROUP BY EMPSTAT, EEOCLASS, GENDER ORDER BY AGE ASC, GENDER ASC
There is extra empty space included before the ORDER BY. This is not
handled by 3.1.0.4 and so it fails.
Removing the extra space from the xml file associated with the query may
correct the problem.
A fix for this issue is available at:
http://www.sas.com/techsup/download/hotfix/hr_vision31.html#014452
Operating System and Release Information
| SAS System | SAS Human Capital Management | Microsoft Windows NT Workstation | 3.1 | | | |
| 64-bit Enabled Solaris | 3.1 | | | |
| Solaris | 3.1 | | | |
| HP-UX | 3.1 | | | |
| 64-bit Enabled HP-UX | 3.1 | | | |
| Microsoft Windows 2000 Professional | 3.1 | | | |
| AIX | 3.1 | | | |
| 64-bit Enabled AIX | 3.1 | | | |
*
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: | Usage Note |
| Priority: | medium |
| Date Modified: | 2005-02-24 08:13:16 |
| Date Created: | 2005-01-31 16:14:43 |
