In a RB 3.0 MDX dataset I have a parameter named @Status. The cube also has a dimension named Status and an attribute in the dimension named Status. The query worked fine on our development server, but when installed in a new environment
I'm now getting an error "Query execution failed for dataset1. The syntax for 'Status' is incorrect".
The parameter is mapped correctly to a valid value. If I change the name of the parameter to anything (e.g. @Status2) the query executes fine. The new environment was generated from the development server.
What could be causing this issue with the parameter name ?
Since you have a working report and non-working, can you run a SQL Server profiler trace Against analysis services with Query begin , Errors and end event and then try and run the reports. The query begin event will have the Parameters and the query submitted
to Analysis services, you would notice the error for the query and can match it with the working ones.