In some cases, using the NON EMPTY CROSSJOIN operation to optimize an OLAP query can result in slower performance. The most likely cause is a security condition on the data that prevents access to the All member of the hierarchy. As a workaround, include the All member as part of the security condition.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Note: If you are using Microsoft Windows and you downloaded the hot fix before July 3, 2009, then you should download and apply the hot fix again. The hot fix for Microsoft Windows was repackaged on July 3, 2009, because the original package caused problems when building cubes.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: