The following zip files include the Demo code used in the Pass European Conference 2010.

Management Studio Solution

Visual Studio Solution

Session Details: Every data mart and data warehouse needs a time dimension to use in date related business analysis. We will review some of the techniques that experience BI developers use to create exciting time dimensions that help users perform usual and unusual business analytics. The additional attributes will allow end users your cubes to calculate averages, accumulated measures, growth and other calculated measures.