Usage Note 7806: Accessing OLAP cube that contains a currency type will return $0
When using SAS/Access Interface to OLEDB with SAS V8.2 on Windows with
the Microsoft OLE DB Provider for OLAP services to access an OLAP cube
that contains data of the CURRENCY type (DBTYPE_CY), SAS returns $0 as
the value for that data instead of the correct value. This problem has
existed since the beginning of the MDX functionality.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#007806
For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#007806
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft Windows NT Workstation | 8.2 TS2M0 | |
| Microsoft Windows XP Professional | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 8.2 TS2M0 | |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | |
*
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: | Usage Note |
| Priority: | medium |
| Topic: | Third Party ==> Information Exchange ==> OLE DB (Object Linking and Embedding Database)
SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> OLEDB
|
| Date Modified: | 2002-09-09 10:26:22 |
| Date Created: | 2002-06-19 11:11:43 |
