Problem Note 14324: Restricting default measure will cause error in MDX queries
There is an error in processing MDX queries where the default measure
has restrictions. Normally the SAS OLAP server will select another
default measure/member if a restriction is found on the current
measure/member. Currently the server does not select another default
measure causing an access denied error when the default measure is
requested.
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#014324
For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014324
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS OLAP Server | Tru64 UNIX | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| 64-bit Enabled AIX | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| OpenVMS Alpha | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| 64-bit Enabled HP-UX | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| HP-UX IPF | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Linux | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| z/OS | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| 64-bit Enabled Solaris | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Server | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft Windows NT Workstation | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
| Microsoft Windows XP Professional | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
*
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.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Third Party ==> Programming ==> MDX (Multiple Expression Language)
Query and Reporting ==> OLAP (Online Analytical Processing)
|
| Date Modified: | 2005-04-08 15:24:33 |
| Date Created: | 2005-01-21 17:10:15 |
