Groups | Blog | Home
all groups > sql server reporting services > november 2004 >

sql server reporting services : Dynamic MDX Deployement in Reporting Services


AndyT
11/16/2004 3:03:10 PM
I have created a Reporting Services report that uses MDX to retrieve data
from a cube. The MDX statements must use a parameter so they are placed into
text strings. The report will run with the Dynamic MDX in Visual Studio but
when I deploy it to the Web Server it locks up.

I believe that the dynamic MDX is causing the problem. The reports that
connect to the Cube that do not use parameters run fine on the web.

Any advice would be appreciated.
johnE
11/17/2004 1:40:04 PM
I found this to be very helpful with parameterized MD
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp


[quoted text, click to view]
AddThis Social Bookmark Button