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
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.
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.
Thanks for the answer!
However, once you have this done, it is definitely possible to make this connection. We've done it a number of times.
Tom
There are some topics in the SAS OLAP Server User's Guide that may also be of use. See the topics:
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.