Problem Note 13365: Drill-through and ROLAP aggregation tables can fail if the MDX query contains a numeric member
 |  |  |  |  |
A request for drill-through data or a ROLAP aggregation table might return an empty table or an error if the query that is sent to the SAS® OLAP Server contains a long numeric value for one of the levels in the cube. For example, if the level PRODUCT_ID contains numeric IDs such as 2102002005, the query that is sent to the server will have converted the number into floating point representation, 2.102002005E+11. This causes the query to fail.
Depending on the Java locale for your environment, the exception returned by a client might be different. For example, some locales might format the value as 2,102002005e9. With an English locale, numeric values with an absolute value greater than 999999 will produce this problem.
As a workaround, before building the cube, make sure that all classification variables are stored as character.
The available hot fix resolves only the case where an empty set of data is returned. If your data contains numeric values as described above, an error message might still be returned after applying the hot fix.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Server | Tru64 UNIX | 9.1 | 9.2 TS2M0 |
| 64-bit Enabled AIX | 9.1 | 9.2 TS2M0 | ||
| OpenVMS Alpha | 9.1 | 9.2 TS2M0 | ||
| 64-bit Enabled HP-UX | 9.1 | 9.2 TS2M0 | ||
| HP-UX IPF | 9.1 | 9.2 TS2M0 | ||
| Linux | 9.1 | 9.2 TS2M0 | ||
| z/OS | 9.1 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 9.1 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Professional | 9.1 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Server | 9.1 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 | 9.2 TS2M0 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 | 9.2 TS2M0 | ||
| Microsoft Windows NT Workstation | 9.1 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 9.1 | 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#013365A 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#013365| Type: | Problem Note |
| Priority: | medium |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing) System Administration ==> Servers ==> OLAP |
| Date Modified: | 2008-06-12 13:32:14 |
| Date Created: | 2004-09-21 16:32:15 |