Databases Reference
In-Depth Information
Table 7-1
Date Dimension Attribute Definitions
ATTRIBUTE
DEFINITION
SAMPLE VALUES
NAME
Day
Calendar day information was reported
6/31/2003,
9/1/2003
Holiday
This is a future attribute to indicate the
name of the federal holiday recognized
by the U.S. government.
Memorial Day,
President's Day
Fiscal Week
The week of the fiscal year that this date
rolls up to; used for reporting purposes
FY 2003 Week 16
Fiscal Month
The month of the fiscal year that this date
rolls up to; used for reporting purposes
FY 2003-10, FY
2003-11
Fiscal Quarter
The quarter of the fiscal year that this date
rolls up to; used for reporting purposes
FY 2003-Q1, FY
2003-Q2
Fiscal Year
The year that this date rolls up to based
upon the company's fiscal calendar
FY 2003
Calendar Month
The calendar month used for reporting
purposes
March 2003,
October 2003
Calendar Quarter
The calendar quarter used for reporting
purposes
CY 2003-Q1, CY
2003-Q2
Calendar Year
The calendar year used for reporting
purposes
CY 2003
Calendar Week
The calendar week ending Saturday and
used for reporting purposes
Week Ending
11/21/1998
Day of Week
Attribute to indicate the calendar day of
the week
Wednesday,
Saturday
Figure 7-4 shows a fact group for retail sales. The name of the fact group is
in the hexagon at the center of the diagram. Each dimension that applies to this
fact group is diagrammed as a bubble around the hexagon. The specific grain is
also included in each bubble. This is important because facts can have similar
dimensionality, but be at different levels of detail. If you have two facts that
have the same dimensions but one is daily and the other is monthly, these must
be split into two separate fact groups. You must design only single-grain fact
groups. Mixing the grain of a fact group can cause query results to be incorrect.
TIP
Never mix the grain of facts in a fact group.
