Sunday, October 26, 2008

Time Dimension and Adding Intelligence in SSAS

If you are building a Analysis Services cube by trying to take advantage of the inbuilt time dimension. This article is a must read.
http://www.mssqltips.com/tip.asp?tip=1454
It also explains in detail about adding the built in features of business intelligence to the generated hierarchy and provides some calculation for periodic growth figures.