The SAS Output Delivery System and reporting techniques

Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 75
Accepted Solution

Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

Hello,

I have an OLAP cube in SSAS named "Prices Cube". The cube is stored in an SQL Server intance named "andreas-pc\datamart". SAS foundation is also installed on the same pc. I read in a paper that SAS can be connected to the SQL SSAS Olap cube throgh OLE DB. So i am trying to set up a library with OLE DB conncetion. I set the provider as "MSOLAP", the datasource as "Prices Cube" and i enter the username and password of the SQL Server instance and nothing on propeeties but i get "ERROR: trying to establish connection: Unable to initialize. Check SAS Log fpr possinble additional info". There is nothing at the Log.Is it somethign that i am missing? ANy ideas on how i could connect to the OLAP cube?

Thnaks in advance,

Andreas


Accepted Solutions
Solution
‎05-28-2012 07:18 PM
Respected Advisor
Posts: 2,903

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

To use OLE DB in SAS you need to have the SAS/ACCESS to OLE DB product licensed.

Run: PROC SETINIT NOALIAS; RUN; to confirm.

View solution in original post


All Replies
Solution
‎05-28-2012 07:18 PM
Respected Advisor
Posts: 2,903

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

To use OLE DB in SAS you need to have the SAS/ACCESS to OLE DB product licensed.

Run: PROC SETINIT NOALIAS; RUN; to confirm.

Frequent Contributor
Posts: 75

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

Thanks for the answer!

Trusted Advisor
Posts: 1,030

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

However, once you have this done, it is definitely possible to make this connection. We've done it a number of times.

Tom

SAS Employee
Posts: 5

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

There are some topics in the SAS OLAP Server User's Guide that may also be of use. See the topics:


  • Accessing OLAP Cubes from SAS : SQL Pass-Through Facility for OLAP

  • Connecting to a SAS OLAP Server Using the OLEDB Protocol
New Contributor
Posts: 3

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

Hi, there

To set up an ODBC Data Source, select the Start Menu, click on Settings Æ Control Panel and choose Administrative Tools. From there, choose Data Sources (ODBC). This will open the Data Source Administrator.

See You

Post a Question
Discussion Stats
  • 5 replies
  • 3236 views
  • 6 likes
  • 5 in conversation