Problem Note 30537: SAS MDX isEmpty function will not evaluate cells containing character data
The MDX function defined by the SAS OLAP Server will only evaluate numeric or null cells. If a cell containing a character value is passed to the function, an MDX error will be returned.
Since the SAS Java clients make use of the isEmpty function when evaluating totals, any measure column which contains a character string will cause an error. The only workarounds available for this behavior are to not use totalling when displaying a measure that contains a character string, or to convert the character string to a numeric value when appropriate.
Operating System and Release Information
| SAS System | SAS OLAP Server | z/OS | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft® Windows® for x64 | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS2M0 |
| Windows Vista | 9.1 TS1M3 | 9.2 TS2M0 |
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS2M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS2M0 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS2M0 |
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS2M0 |
| Linux | 9.1 TS1M3 | 9.2 TS2M0 |
| Linux on Itanium | 9.1 TS1M3 | 9.2 TS2M0 |
| OpenVMS Alpha | 9.1 TS1M3 | 9.2 TS2M0 |
| Solaris for x64 | 9.1 TS1M3 | 9.2 TS2M0 |
| Tru64 UNIX | 9.1 TS1M3 | 9.2 TS2M0 |
*
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.
The MDX function defined by the SAS OLAP Server will only evaluate numeric or null cells. If a cell containing a character value is passed to the function, an MDX error will be returned.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing)
|
| Date Modified: | 2007-11-14 17:49:02 |
| Date Created: | 2007-11-13 12:26:22 |
