https://communities.sas.com/t5/SAS-Enterprise-Guide/connecting-to-OLAP-Server/m-p/3558#M1167 Are you looking for something like this:<BR /> <BR /> /* supply your correct olap host machine and port */<BR /> PROC SQL; <BR /> CONNECT TO OLAP (HOST="myOlapServer" PORT=7994);<BR /> CREATE TABLE WORK.SLICE AS<BR /> SELECT * FROM CONNECTION TO OLAP<BR /> (SELECT <BR /> { CrossJoin ( { [TIME].[YWD].DefaultMember.Level.Members } , { [Measures].[COSTPRICE_PER_UNITAVG] } ) } ON COLUMNS , { [CUSTOMERS].[All CUSTOMERS].Children } ON ROWS FROM<BR /> [DETAIL]<BR /> );<BR /> DISCONNECT FROM OLAP;<BR /> RUN;<BR /> QUIT; Thu, 28 Jun 2007 20:10:33 GMT ChrisHemedinger 2007-06-28T20:10:33Z https://communities.sas.com/t5/SAS-Enterprise-Guide/connecting-to-OLAP-Server/m-p/3557#M1166 Can any one send me the base sas code for connecting to OLAP Server. Mon, 25 Jun 2007 06:52:08 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/connecting-to-OLAP-Server/m-p/3557#M1166 deleted_user 2007-06-25T06:52:08Z https://communities.sas.com/t5/SAS-Enterprise-Guide/connecting-to-OLAP-Server/m-p/3558#M1167 Are you looking for something like this:<BR /> <BR /> /* supply your correct olap host machine and port */<BR /> PROC SQL; <BR /> CONNECT TO OLAP (HOST="myOlapServer" PORT=7994);<BR /> CREATE TABLE WORK.SLICE AS<BR /> SELECT * FROM CONNECTION TO OLAP<BR /> (SELECT <BR /> { CrossJoin ( { [TIME].[YWD].DefaultMember.Level.Members } , { [Measures].[COSTPRICE_PER_UNITAVG] } ) } ON COLUMNS , { [CUSTOMERS].[All CUSTOMERS].Children } ON ROWS FROM<BR /> [DETAIL]<BR /> );<BR /> DISCONNECT FROM OLAP;<BR /> RUN;<BR /> QUIT; Thu, 28 Jun 2007 20:10:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/connecting-to-OLAP-Server/m-p/3558#M1167 ChrisHemedinger 2007-06-28T20:10:33Z