Reporting Services OLAP Report through Report Manager

I am creating a report in Reporting Services that hits an Analysis services
cube using MDX. The report has parameters so some of the MDX queries are
placed into strings. When running the report on my local machine it works
correctly, but when I deploy the report and run it through Report Manager it
locks up and will not display. It also brings down the Web server for a few
minutes.
The parameter lists in the report are created with a static MDX statement
and they will display, but the report keeps turning and never renders to the
screen.
I have looked at the site
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
but I cannot find anything on why the report would work locally but not
through Report manager.
Any advice or directions would be greatly appreciated.I was able to solve this problem. The SQK server with my Cubes had Analysis
Services SP3. The box that I was developing the OLAP report was also running
AS SP3 but the Report Server did not have any service packs installed. This
was causing the OLAP report to lock up on the report server. Analysis
services was installed onto the report server after the report server and
visual studio. I believe that Analysis services over wrote the MSOLAP80.dll
to the 8.0.195 version.
After installing AS SP3 on the report server I was able to view OLAP Reports
through the Report Manager without locking up or bring down the web server.
"AndyT" wrote:
> I am creating a report in Reporting Services that hits an Analysis services
> cube using MDX. The report has parameters so some of the MDX queries are
> placed into strings. When running the report on my local machine it works
> correctly, but when I deploy the report and run it through Report Manager it
> locks up and will not display. It also brings down the Web server for a few
> minutes.
> The parameter lists in the report are created with a static MDX statement
> and they will display, but the report keeps turning and never renders to the
> screen.
> I have looked at the site
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
> but I cannot find anything on why the report would work locally but not
> through Report manager.
> Any advice or directions would be greatly appreciated.
>