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 and is downloadable here.