Monthly Archives: August 2009

Effects of semi-additive measures on other dimensions

Semi-additive measures are measures that don’t use the same aggregation method along all of the cube’s dimensions. In SSAS the time dimension plays an important role here. For example, if you choose the ‘AverageOfChildren’ aggregation method, the measure is averaged … Continue reading

Posted in Allgemein | Leave a comment

Calculating the proper ISO week for the time dimension

There are some definitions for calendar weeks and T-SQL offers many of those calculations out of the box. When you’re doing projects in Europe you will frequently find the ISO week definition for the calendar week as of ISO 8601. … Continue reading

Posted in Allgemein | Leave a comment

Book recommendation: Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

So here is my first book recommendation in this blog. The authors (Chris Webb, Alberto Ferrari and Marco Russo) are all well known Analysis Services experts and they did a pretty good job in writing this book. It is fully … Continue reading

Posted in Allgemein | Leave a comment