Problem Note 44715: Performance enhancement enables the underlying data source to calculate TOPCOUNT and BOTTOMCOUNT for an OLAP query
 |  |  |  |  |
The TOPCOUNT and BOTTOMCOUNT MDX functions currently fetch and order all tuples of the source set even if only a small number of tuples will be returned to the final result set.
For example, if a set contains 500,000 tuples but only the top 5 are requested, then the processing of the other 499,995 tuples is unnecessary.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Once the performance enhancement is in place, when a ROLAP query contains simple stored measures, the SAS® OLAP Server will pass the TOPCOUNT and BOTTOMCOUNT query down to the underlying data source to more efficiently return the final rows in the correct order.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Server | HP-UX IPF | 9.2 TS2M0 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Windows Vista | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Windows Vista for x64 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.3 TS1M1 | ||
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.3 TS1M1 | ||
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.3 TS1M1 | ||
| z/OS | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Linux | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Linux for x64 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| OpenVMS on HP Integrity | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Solaris for x64 | 9.2 TS2M0 | 9.3 TS1M1 | ||
A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#44715| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-11-07 08:56:42 |
| Date Created: | 2011-10-25 14:46:38 |