Query Execution failed for dataset error / the syntax for " " is incorrect

Hi,

Am totally new to MDX Queries.

I got this error while previewing a report that we had made. It goes like this --

Query execution failed for dataset 'some_dataset'.

Parser: the syntax for 'some_character' is incorrect.

What was figured out was this error shows up only for those values in a particular dropdown list which are multiword. Eg : My Company Technology and not for those values which a re single word. Eg : Company

what could be the possible problem and the solution to that.

Try to use [My Company Technology] as parameter value.|||

I dont wish to hard code the values.

It should be dynamic

|||

Hi Madu,

here you can find the rules for the identifiers in MDX:

http://msdn2.microsoft.com/en-us/library/ms145572.aspx