THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Don't use quote inside comments with Analysis Services 2000

Yesterday I lost at least an hour (but only for a coincidence I haven't lose more hours) because I came across a bug of Analysis Services 2000.

If you put a single quote or a double quote inside a comment, the whole MDX expression is not considered. I had the problem in a custom rollup formula, but it's a problem of MDX in any context when the comment is in the middle of a MDX formula; unfortunately, the whole rollup formula is probably considered inside a larger MDX expression so the bug is more critical in this context.

I wrote about the bug in the newsgroup and Deepak Puri kindly answered that it's a known bug, already found by George Spofford almost three years ago (I tried to search about the bug but I haven't found this message before my post). This bug is already known by Microsoft and it's larger than I initially thought: in a later thread (of 2003) it was noted that the bug infect the overall parsing of MDX formula when a comment is inside (and as I said before, in the case of rollup formula the whole MDX formula is subject to this bug).

I hope SP4 will solve this oooold bug, so we don't waste our time next time we use comments in a MDX formula: in italian language the use of single quote is much more frequent than in english...

Published Sunday, January 9, 2005 7:45 AM by Marco Russo (SQLBI)


No Comments
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement