Hi Lidou123 - Do you really mean MDX script? That term applies to the calculations, named sets, and KPIs that one adds to the cube definition and doesn't involve the SSRS query builder in any way. Is that what you mean or do you mean something else? If you mean the MDX script, the answer is no - it is not possible to use parameters there. Now if ...

RD, Your question isn't very clear on what you mean, but perhaps this post is helpful: http://sqlblog.com/blogs/stacia_misner/archive/2011/02/04/33208.aspx

Hi Solomon - If you have to click View Report to run your report, does your report run correctly? If so, then your report query is fine. If you have to click View Report, that means one or more of the report parameters does not have a default value set (or does not have it set correctly).

Normally I run SQL queries against the source and validate against the corresponding results in the OLAP data.

Happy to help! :)

Joanne, this feature is not available in Reporting Services 2005. You must have 2008 or higher.

Thanks,  Suhas!

Thanks, Davide and Jason - I was hoping to spark a conversation about other tools, and I succeeded! I appreciate the time you took to read this post ad your suggestions for other tools. SharePoint Experts London - I'm glad you found the post useful.

Thanks, Boyan - the astute reader will notice that point when they check out the link for clearing the file system cache. I just have old habits that die hard, and will admit I don't always clear the file system cache depending on what I'm up to, so I didn't think to point it out. Anyway, you're right - if someone is going to register an ASSP ...

In one my recent MDX classes, a student asked about automation of MDX queries for the purposes of testing query performance, so today I’ll answer that question and draw your attention to a few resources available.Get the ASCMD UtilityIf you’re running SQL Server 2008 Analysis Services or SQL Server 2008 R2 Analysis Services, you can download ...