topic Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/337988#M18067 <P>Hi, there</P><P>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.</P><P>See You</P> Fri, 03 Mar 2017 20:08:45 GMT BoelterBI 2017-03-03T20:08:45Z Connect to SQL Server Analysis Services OLAP Cube Through Base SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127430#M10625 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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?</P><P></P><P></P><P>Thnaks in advance,</P><P></P><P></P><P>Andreas</P></BODY></HTML> Mon, 28 May 2012 03:39:28 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127430#M10625 andreas_zaras 2012-05-28T03:39:28Z Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127431#M10626 <HTML><HEAD></HEAD><BODY><P>To use OLE DB in SAS you need to have the SAS/ACCESS to OLE DB product licensed.</P><P></P><P>Run: PROC SETINIT NOALIAS; RUN; to confirm.</P></BODY></HTML> Mon, 28 May 2012 23:18:10 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127431#M10626 SASKiwi 2012-05-28T23:18:10Z Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127432#M10627 <HTML><HEAD></HEAD><BODY><P>Thanks for the answer!</P></BODY></HTML> Tue, 23 Oct 2012 07:52:39 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127432#M10627 andreas_zaras 2012-10-23T07:52:39Z Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127433#M10628 <HTML><HEAD></HEAD><BODY><P>However, once you have this done, it is definitely possible to make this connection. We've done it a number of times.</P><P></P><P>Tom</P></BODY></HTML> Tue, 23 Oct 2012 14:57:08 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127433#M10628 TomKari 2012-10-23T14:57:08Z Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127434#M10629 <HTML><HEAD></HEAD><BODY><P style="margin-top: auto; margin-bottom: auto;"><SPAN style="color: windowtext; letter-spacing: 0pt; font-family: 'Times New Roman','serif'; font-size: 12pt; mso-fareast-font-family: 'Times New Roman'; mso-font-kerning: 0pt;">There are some topics in the SAS OLAP Server User's Guide that may also be of use. See the topics:</SPAN></P><UL><LI><BR /><SPAN style="letter-spacing: 0pt; font-family: 'Times New Roman','serif'; font-size: 12pt; mso-fareast-font-family: 'Times New Roman'; mso-font-kerning: 0pt;">Accessing OLAP Cubes from SAS : SQL Pass-Through Facility for OLAP</SPAN></LI><LI><BR /><SPAN style="letter-spacing: 0pt; font-family: 'Times New Roman','serif'; font-size: 12pt; mso-fareast-font-family: 'Times New Roman'; mso-font-kerning: 0pt;">Connecting to a SAS OLAP Server Using the OLEDB Protocol</SPAN></LI></UL></BODY></HTML> Wed, 12 Dec 2012 17:14:36 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/127434#M10629 DLanningham 2012-12-12T17:14:36Z Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/337988#M18067 <P>Hi, there</P><P>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.</P><P>See You</P> Fri, 03 Mar 2017 20:08:45 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Connect-to-SQL-Server-Analysis-Services-OLAP-Cube-Through-Base/m-p/337988#M18067 BoelterBI 2017-03-03T20:08:45Z