Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

[andreas_zaras]

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

[SASKiwi · Accepted solution]

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.

[andreas_zaras]

Thanks for the answer!

[TomKari]

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

Tom

[DLanningham]

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

[BoelterBI]

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