Problem Note 14307: "Excel received data from the source database that could not all be
displayed."
When trying to view more than one calculated measure from your OLAP cube
in Microsoft Excel, you may encounter the following error:
Excel received data from the source database that could not all be
displayed. You may be able to display the data by clicking the
Refresh Data button on the PivotTable toolbar
The problem is coming from an apparent case sensitivity compare being
done on the Microsoft Excel side between the measure unique name and the
dimension name. The SAS OLAP cube preserves the user-specified case of
the calculated measure unique name, which may not match the case of the
Measures dimension name that Microsoft Excel is expecting.
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#014307
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#014307
Operating System and Release Information
| 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: | System Administration ==> Servers ==> OLAP
Query and Reporting ==> OLAP (Online Analytical Processing)
|
| Date Modified: | 2005-05-11 11:41:17 |
| Date Created: | 2005-01-21 14:09:18 |
