Problems connecting to the SAS OLAP Server in MS EXCEL after downloading ONLY the SAS OLAP Data Provider on a virgin SAS Machine?
When installing the SAS OLAP Data Provider for use in MS Excel Pivot Tables, be sure to use the Integrated Technologies for Windows download, rather than the SAS OLE DB download. The later works fine on machines that already have SAS EG (or BASE) installed, but for virgin machines, go to the following website to download the components:
http://www.sas.com/apps/demosdownloads/
inttechclientwn_PROD_9.1_sysdep.jsp?packageID=000301