The time dimension is a special dimension used to describe a business in terms of when things happened. Time dimensions are meant to answer questions related to time, for example, do I sell more on Mondays or on Fridays? Am I selling more this quarter than the same quarter last year? Depending on the kind of question you want to answer, is the list of attributes you need to include in your time dimension. Typical fields in a time dimension are year, month (a number between 1 and 12), description of month, day of month, weekday, and quarter.
In terms of databases, a time dimension table has one row for every date in a given range of dates and one column for each attribute describing the date.
In Chapter 2, Getting ...
