From the course: SQL Server Analysis Services

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Incorporating time intelligence

Incorporating time intelligence - SQL Server Tutorial

From the course: SQL Server Analysis Services

Start my 1-month free trial Buy for my team

Incorporating time intelligence

“

- [Instructor] Time intelligence functions and decks allow you to use values for different time periods at the same time. And this can be very helpful for creating measures to gauge progress over time and allow you to do comparison analysis within reports. There are a number of different functions which incorporate time intelligence, and there are some requirements which the models must include. To be able to create time intelligence functions, your model must contain a date table. The date table needs to contain dates for as many years as you have within your fact table and must contain a column with a unique date without any gaps in it. Some people like to fill empty date values with a date far into the past instead of leaving that field blank. For example, January 1st, 2000. If your date values within your fact table contain that value, that means your date table will also need to start at January 1st, 2000 as well.…

Contents