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

Report Builder trouble filtering date with UDM

Thanks to a blog reader, I just discovered that if you create a Report Builder Model from a UDM and try to create a report filtering a date field, the date you specify in the filter dialog box is inverted (months with days) when the MDX query is generated. At first glance I thought it was another locale ID compliance problem, but I just tried with en-us and it makes the same error.

The problem shows itself only when you have a day value less or equal to 12. It appears that the conversion is made with CDate function that behaves in that way when it receives a MM-DD-YYYY date format (it inverts the format to DD-MM-YYYY when the DD value is less than or equal to 12). Many thanks to Alberto De Marco who helped me (and many other through this blog) to see this problem.

Now, if someone would have enough time to open a bug with PSS... :-)

Published Tuesday, February 14, 2006 7:17 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