Desktop productivity for business analysts and programmers

connecting to OLAP Server

Reply
N/A
Posts: 0

connecting to OLAP Server

Can any one send me the base sas code for connecting to OLAP Server.
Community Manager
Posts: 2,889

Re: connecting to OLAP Server

Are you looking for something like this:

/* supply your correct olap host machine and port */
PROC SQL;
CONNECT TO OLAP (HOST="myOlapServer" PORT=7994);
CREATE TABLE WORK.SLICE AS
SELECT * FROM CONNECTION TO OLAP
(SELECT
{ CrossJoin ( { [TIME].[YWD].DefaultMember.Level.Members } , { [Measures].[COSTPRICE_PER_UNITAVG] } ) } ON COLUMNS , { [CUSTOMERS].[All CUSTOMERS].Children } ON ROWS FROM
[DETAIL]
);
DISCONNECT FROM OLAP;
RUN;
QUIT;
Ask a Question
Discussion stats
  • 1 reply
  • 117 views
  • 0 likes
  • 2 in conversation