Problem Note 19820: NONEMPTYCROSSJOIN function might cause data loss in an OLAP Query
 |  |  |  |  |
The NONEMPTYCROSSJOIN function might cause some data to be dropped from the OLAP query result. No errors will be reported. This behavior might also be present when the Non Empty Crossjoin Optimization is enabled.
Avoiding the use of NONEMPTYCROSSJOIN and disabling the optimization option through SAS® Management Console are the only ways to prevent this behavior.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Server | Tru64 UNIX | 9.1 TS1M0 | 9.2 TS1M0 |
| 64-bit Enabled AIX | 9.1 TS1M0 | 9.2 TS1M0 | ||
| OpenVMS Alpha | 9.1 TS1M0 | 9.2 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M0 | 9.2 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M0 | 9.2 TS1M0 | ||
| z/OS | 9.1 TS1M0 | 9.2 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.2 TS1M0 | ||
| Microsoft Windows NT Workstation | 9.1 TS1M0 | |||
| Microsoft Windows XP Professional | 9.1 TS1M0 | 9.2 TS1M0 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#019820A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#019820| Type: | Problem Note |
| Priority: | alert |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing) System Administration ==> Servers ==> OLAP |
| Date Modified: | 2007-04-16 11:10:52 |
| Date Created: | 2007-03-22 11:05:26 |