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

DateTool dimension improvement

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.

Published Sunday, September 9, 2007 11:18 PM by Marco Russo (SQLBI)



aferg3121 said:


Thanks for this.  I am an SSAS newbie but was able to get everything working with one exception.  I cannot work out how to get the Date Tool columns to sort by the keys rather than the alphabetic descriptions.  I saw you had your example sorted by key., but after I reprocessed the dimension I found that they too were sorting by the description.  This is onviously undesirable as it would be much better to have Regular first, then Previous Year, Diff over Prev, Diff % over Prev.

Any assistance you may be able to provide would be greatly appreciated as your solution provides a great solution to an unfortunate problem with Excel!



December 9, 2007 10:27 PM

Marco Russo (SQLBI) said:


in the Dimension Editor you can change the "OrderBy" property of the attributes you want to sort by key, using the "Key" value instead of "Name", which is selected by default.



December 10, 2007 2:29 AM

Miguel Chavez said:

First, Congratulations for your great job.

I was trying DateTool, but when I put Calendar on rows and Comparison on Columns , I got same Total Values for all columns.

Where can i send you a image ?

June 1, 2010 1:12 PM
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