Report Portal

ISOWeeks in SSAS Revisited

I wrote a blog post a few years ago about IsoWeeks in SSAS and now it is time to do an update. Since SQL Server 2008 and later we have a TSQL Datepart() argument that will remove the need to build TSQL User Defined Functions to add this information into a date dimension table. You will see this in the code samples but have a look at the datepart() TSQL function i Books On Line for more information.

Read more...

Tags: design, time

 

2007-2015 VidasSoft Systems Inc.