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".
I've seen similar posts like this:
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 ?
Thank you for your question.
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.
Thank you for your understanding and support.
If you have any feedback on our support, please click here.
TechNet Community Support
Hi J. Way,
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.
Let me know if you have any question.