Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  MDX Query in returns NULL values SSRS and returns

Author  Topic  m14cus Starting Member 2 Posts Posted - 2010-12-13 : 08:58:37 I have a MDX query that when run agaisn teh cube from a Query window will return values for the measures. I've since pasted this MDX into a SSRS report and when exectued it onlyu returns null values. I profiled the connection and teh MDX is identical in both scenarios so I know SSRS isn't manipulating the data. Has anyone had a similar problem? Any ideas? Thanks for the help Marcus