Hi,
I am using sql server 2005 reporting service. In my MDX query i have a
"Where" clause. when i execute the query in Report Designer 2005, it
works fine ie. it filters the data as per the "Where" clause. However
when i run the report it ignores the where clause.I am not able to
understand why is it happening. Any help will be appreciated. Thanks in
advance.

Thanks and Regards
Nitin Verma.