PROC SQL with MDX and PROC Print -very slow execution

metalray — Mon, 07 Feb 2011 11:17:48 GMT

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;

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

metalray — Mon, 07 Feb 2011 13:06:52 GMT

nearly two hours have passed and no result. I stopped the program in EG 4.2. I got the port number wrong 😞 - no error message to indicate there was a connection problem.

topic PROC SQL with MDX and PROC Print -very slow execution in Developers

PROC SQL with MDX and PROC Print -very slow execution

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