Analysis Services Step By Step book. When it comes to creating time
dimensions, the example shows all sorts of different fields for
DayNumberOfMonth, DayNumberOfYear etc. My own tables that I want to
create time dimensions all only have a single datetime field, with the
date of an action time stamped in the format dd/MM/YYYY hh:mm:ss. How
can I create a time dimension that breaks down time into
year/month/quarter etc when I only has this one field to work with?