Hi,
My question has two part.
Part1:
I'm a little confused by OLAP and OLE DB provider. in menu File->Open -> OLAP Cube,Information map, OLE DB,...
What is the difference between them to connect to OLAP server?
Part2:
I'm using Base SAS and have OLE DB provider in list of products when I install SAS on my PC and trying to connect to OLAP server via SAS code. I followed the instruction in http://support.sas.com/kb/41/722.html and can connect to OLAP server and see the cubes, but when I try to connect to OLAP server via code in SAS EG I'm getting error.
SAS code:
/* The machine name or IP address for the SAS OLAP server */
%let host=abcd.com;
/* The port number for the SAS OLAP server */
%let port=5451;
/* A User ID with access to the cube */
%let user=user1;
/* The User's password */
%let pass=******;
/* The OLAP cube name */
%let cube=Checkin;
proc sql;
connect to olap (host="&host" port=&port
user="&user" pass="&pass");
select * from connection to olap
(
select [Measures].defaultmember on columns from [&cube]
);
disconnect from olap;
quit;
and error:
54 /* The machine name or IP address for the SAS OLAP server */
55 %let host=abcd.com;
56
57 /* The port number for the SAS OLAP server */
58 %let port=5451;
59
60 /* A User ID with access to the cube */
61 %let user=user1;
62
63 /* The User's password */
64 %let pass=******;
65
66 /* The OLAP cube name
67 %let cube=Checkin;*/
68
69 proc sql;
70 connect to olap (host="&host" port=&port
71 user="&user" pass="&pass");
ERROR: The Bridge Protocol Engine Socket Access Method was unable to connect to abcd.com, port 5451.
ERROR: The TCP/IP tcpSockConnect() support routine failed with error 110 (The connection has timed out.).
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
72 select * from connection to olap
73 (
74 select [Measures].defaultmember on columns from [&cube]
75 );
ERROR: Connection to the olap DBMS does not exist.
ERROR: IOM call failed.
76 disconnect from olap;
NOTE: Statement not executed due to NOEXEC option.
77 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 1:03.03
cpu time 0.04 seconds
83 %_eg_hidenotesandsource;
95
96
97 %_eg_hidenotesandsource;
What could be the issue?
... View more
