Report Portal

SQL Server Analysis Services 2005: Time Intelligence solutions on the web

Here is a list of links to pages that talks about Time intelligence implementation in Microsoft SQL Server Analysis Services.

SQL Server 2005 Books Online: Defining Time Intelligence Calculations using the Business Intelligence Wizard

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

Analysis Services 2005 Brings You Automated Time Intelligence (by Mosha Pasumansky and Robert Zare)

A Different Approach to Implementing Time Calculations in SSAS (By David Shroyer)
  Recommendations regarding article above by Mosha Pasumansky and how to handle parallel periods

Multiple Time Utility Dimensions (By Chris Webb)
Time Utility Hierarchies (again) and Attribute Overwrite (by Chris Webb)
Handling Relative Time Periods (by Chris Webb)

 

Known issues: 

You may experience problems after you run the Business Intelligence Wizard to add time calculations in SQL Server 2005 Analysis Services

Time intelligence - still failing at the lowest level in SP1. Fixed in SP2

 

Tags: time dimension

 

2007-2015 VidasSoft Systems Inc.