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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.