Tuesday, February 14, 2006 - Posts

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... :-)

posted Tuesday, February 14, 2006 7:17 AM by marcorusso with 1 Comments

Post SP4 hotfixes for Analysis Services 2000

I just discovered that some weeks ago Microsoft released a cumulative upgrades of hotfixes for Analysis Services 2000 released after SP4. I have to say that I noted AS2000 is less stable after SP4 intallation (I can say that after months of use) and I randomly got event ID 132 that appears to be resolved by SP4 but I've never seen before SP4 (btw, it seems that a pretty invasive backup program lock a file that should be deleted when this happens, so it should be not a SP4 responsibility). I have no time to open a call to Microsoft Support (it's a very expensive process) - I hope Microsoft will improve the way a user can submit a bug (service shutdown seems to be a good candidate) in a production system...

An equivalent post-SP4 cumulative upgrades of hotfixes is also available for the relational part of SQL Server 2000.

posted Tuesday, February 14, 2006 3:43 AM by marcorusso with 1 Comments