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;
