Problem Note 19418: AGGREGATE MDX function might cause slow query performance when member-level security is defined to the OLAP cube
 |  |  |  |  |
When querying an OLAP cube that has member-level security defined, you might experience slower than expected performance when the AGGREGATE MDX function is used within the query in conjunction with the MEMBERS or ALLMEMBERS functions.
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 TS1M3 | 9.2 TS2M0 |
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS2M0 | ||
| OpenVMS Alpha | 9.1 TS1M3 | 9.2 TS2M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS2M0 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Linux on Itanium | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Linux | 9.1 TS1M3 | 9.2 TS2M0 | ||
| z/OS | 9.1 TS1M3 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 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 Professional | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Server | 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® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |||
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS2M0 | ||
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#019418A 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#019418| Type: | Problem Note |
| Priority: | high |
| Topic: | System Administration ==> Servers ==> OLAP Query and Reporting ==> OLAP (Online Analytical Processing) |
| Date Modified: | 2007-01-31 11:07:18 |
| Date Created: | 2007-01-24 09:53:13 |