For time stamp fields in a table, several Dimensions are created automatically and can be used straight away. These Dimensions provide alternative, aggregated views of the original time stamp values.
Calendar Time
Calendar Dimensions, marked with the (
) icon, represent a particular period of time during the year. Each level contains Members that represent exactly one period in time, according to the level.
For example, the Month level will contain Members like January 2008, February 2008, etc. The Days level will contain Members like January 1st 2008, February 1st 2008, etc.
Fiscal Weeks
The Fiscal Weeks Dimension allows for looking at dates and time in terms of fiscal weeks. This Dimension will always contain between 0 and 52 Members, each representing a different fiscal week.
Weekdays
The Weekdays Dimension allows for looking at dates and time in terms of days of the week. This Dimension will always contain between 0 and 7 Members, representing Monday through Sunday.
Aggregated Months
The Aggregate Months Dimension allows for looking at dates in terms of individual months. This Dimension will always contain between 0 and 12 Members, representing January through December.
|
The difference between the Months level in a Calendar dimension and the Aggregated Months Dimension is that a Calendar Dimension contains months within a specific year while the Aggregated Months dimension contains Months without relation to years. If the data contains February 2007 and February 2008, the Calendar Dimension will contain two different February Members (one for 2007 and one for 2008), while the Aggregated Months dimension will contain only one February Member.
|
Aggregated Hours
The Aggregate Months Dimension allows for looking at dates in terms of round hours. This Dimension will always contain between 0 and 24 Members, representing 12am through 11pm.