05-27-2012 11:39 PM
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,
12-12-2012 12:14 PM
There are some topics in the SAS OLAP Server User's Guide that may also be of use. See the topics:
03-03-2017 03:08 PM
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.