Your SAS programs, embedded in web apps and elsewhere

PROC SQL with MDX and PROC Print -very slow execution

Reply
Regular Contributor
Posts: 207

PROC SQL with MDX and PROC Print -very slow execution

Hello,

if I use the following MDX query in the Enterprise Guide OLAP View it takes one second to show me the result.
On the other hand, if I implement it in a stored process, it does not complete. I am running it since 5 minutes now and now success.
I would be very happy for any improvement suggestions.
(the proc print does not work either).

proc sql;
connect to olap (host= myhost.com port=52221 protocol=bridge user=test
pass="{sasenc}4dasdade" repository= Foundation olap-schema="OLAP Schema");

/* pass thru to OLAP line */
create table work.MDXOut as select * from connection to olap
(
/* My MDX Code goes here */



SELECT
CrossJoin(CrossJoin(Hierarchize({ [DIM_KPI].[All DIM_KPI].[TotalSales].[SalesforMarkets],
[DIM_KPI].[All DIM_KPI].[TotalSales].[SalesforMarkets].Children }), { [MEASURES].[FACTSUM] }),
{ [DIM_PERIOD].[All DIM_PERIOD.[2010] }) ON COLUMNS,
Hierarchize({ [DIM_SALES].[All DIM_SALES].[Agencies, [DIM_SALES].[All DIM_SALES].[Agencies].Children,
[DIM_SALES].[All DIM_SALES].[Agencies].[AgenciesUSA].Children }) ON ROWS
FROM
[testcube]




/* End of MDX Code */

disconnect from olap;
/* Disconnect from the OLAP Server */
quit;


Proc print data=work.MDXOut;
var [SalesforMarkets];

run;
Regular Contributor
Posts: 207

Re: PROC SQL with MDX and PROC Print -very slow execution

nearly two hours have passed and no result. I stopped the program in EG 4.2. I got the port number wrong Smiley Sad - no error message to indicate there was a connection problem.
Ask a Question
Discussion stats
  • 1 reply
  • 258 views
  • 0 likes
  • 1 in conversation