Mastering Enterprise BI: Time Intelligence Pt. II By William Pearson

In this article, we will continue our examination of Analysis Services 2005 features that support the Time Analysis Services 2005 cube models. In our last article, Mastering Enterprise BI: Time Intelligence Pt. I, we focused upon adding a Time dimension to an Analysis Services 2005 cube, together with the underlying support via schema generation. Thus far, our concentration has been upon the basic support of the information consumers’ needs to perform analysis based upon the simple selection of specific years, months, and other levels of the Time dimension. dimension within our

In this article, we will examine fulfillment of the need to support additional common business requirements surrounding the Time dimension. As we stated in the aforementioned previous article of our series, as well as in Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part I and Part II, as a part of the special focus upon the Time dimension within their design, support for the dynamic creation of various “relative” time periods and aggregations - flexible date calculations built into our model, such as a Month-to-Date value, Year-over-Year Growth (value or percent are common), and so forth - has been supported within enterprise business intelligence applications, for some time.

Read more...