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

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :