MDX scripts

Hi all,
I would like to retrive data from my datawarehouse cube and make a report. But I got a problem when I ran a report dataset by MDX. First I checked the same MDX script in the MDX sample application and it worked. Then I ran it in the report, it took a long time and gave me an internal error. So, I simplified the script to remove one crossjoin and got the results. I don't know what's wrong with the reporting service.
I would very appreciate if anyone give me some suggestions.
Thanks
ymliu
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Use SQL Profiler to see the SQL being executed
Jeff
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:#VN8fF2lEHA.3712@.TK2MSFTNGP15.phx.gbl...
> Hi all,
> I would like to retrive data from my datawarehouse cube and make a report.
But I got a problem when I ran a report dataset by MDX. First I checked the
same MDX script in the MDX sample application and it worked. Then I ran it
in the report, it took a long time and gave me an internal error. So, I
simplified the script to remove one crossjoin and got the results. I don't
know what's wrong with the reporting service.
> I would very appreciate if anyone give me some suggestions.
> Thanks
> ymliu
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.