I fixed an issue of the DateTool dimension I presented in a previous post. The DateTool was unusable on OWC 11, which is the component used by BI Dev Studio and SQL Server Management Studio to browse a cube. I only added two statements in MDX Script that assign the original value when a selection of all years / all months is made. It seems that OWC 11 defines what members will be shown in the pivot table with a different technique than the one used by Excel 2007. The new version of the DateTool is 0.6.0.0 and is downloadable here.

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2007/09/09/datetool-dimension-improvement.aspx