In my application i use an SQL OpenRowset to execute an MDX query . It works
fine with different mdx queries.
If i use an MDX query with a "very long length" (more than 4000 characters),
the openrowset return an error (incorrect syntax near...) but the syntax is
ok, also "quota problems" ok.
It seems to be an error relative to another problem, maybe the length, and
not the syntax.
If i execute the mdx query in the analysis services sample application it
works.
Any ideas?

Thanks!

Yeah, had that problem...!

In the end I had to create some server side named sets with the members
in to reduce the size of the MDX. If you can't do that then you might
some problems. If you're populating the set of members dynamically then
you'll need to pre populate the named set before running your
openrowset.

Steve