When attempting to drill through I encounter the following error -

Unable to drill through.
Data source provider error. Line 1: Incorrect syntax near ','.;42000

I have other cubes on the same server where the drill through works fine.
The only differences between these and this cube (apart from the application)
is this cube has twenty-one dimensions and about one hundred measures.

I tried removing dimensions but this made no difference.

Any ideas, comments etc gratefully received.

Thanks.

I add the related KBs.

http://support.microsoft.com/kb/293528/EN-US/
http://support.microsoft.com/default.aspx/kb/313279

I think you'd better check the generated SQL using Profiler.

Ohjoo Kwon

"Sunil" <Sunil (AT) discussions (DOT) microsoft.com> wrote