•Requirement – Report on both a monthly and quarterly
basis.
•Do we
–Construct separate fact tables for
month and quarter
–Modify the month dimension to indicate
when a month is the last month in a quarter
–Create a period dimension that includes
month, quarter and year rows
–