THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
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 0.6.0.0 and is downloadable here.

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

aferg3121 said:

Marco,

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!

Cheers

Andrew

December 9, 2007 10:27 PM
 

Marco Russo (SQLBI) said:

Andrew,

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.

Best,

Marco

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

Leave a Comment

(required) 
(required) 
Submit

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

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement