Usage Note 494: Can SAS access Microsoft SQL Server OLAP cubes?
SAS/Access Interface to OLE DB beginning with SAS V8.1 can access
Microsoft Sql Server OLAP cubes. The SAS/Access product requires that
the OLAP Services provider be installed on the same machine as the
interface. To obtain the OLAP Services MSOLAP provider "Microsoft OLE
DB Provider for OLAP Services" install the MSOLAP client from SQL Server
7.0. MDAC 2.5/2.6 does not install it.
There is a known defect using the "Microsoft OLE DB Provider for Olap
Services 8.0" which is version 8.00.194 installed with Sql Server 2000
MSOLAP Client. We have provided a hotfix around this MSOLAP provider
defect with SAS V8.2.
A Technical Support hot fix for Release 8.2 TSLEVEL 2M0 for this
problem is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#000494
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#000494
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft Windows NT Workstation | 8.2 TS2M0 | |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 8.2 TS2M0 | |
| OpenVMS Alpha | 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: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> OLEDB
SAS Reference ==> LIBNAME Engines
Third Party ==> Information Exchange ==> OLE DB (Object Linking and Embedding Database)
|
| Date Modified: | 2002-04-23 14:55:14 |
| Date Created: | 1999-03-22 00:00:00 |
