SAS OLAP Data Provider Install Tip

0

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

Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Comments are closed.

Back to Top