Time Dimension Mastering Enterprise BI: Time Intelligence Pt. II By William Pearson
| Mastering Enterprise BI: Time Intelligence Pt. II By William Pearson |
| Written by William Pearson |
| Saturday, 19 May 2007 19:03 |
|
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. |
Tags: 2005, article, time dimension
Latest Author Articles
- Simple Bar Chart for Analysis Services Data
- Introduction to Attribute Relationships in MSSQL Server Analysis Services
- Simple Column Chart for Analysis Services Data
- Further Combination of BottomCount() with Other MDX Functions
- Combine BottomCount() with Other MDX Functions to Add Sophistication
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
