|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
By default, week 1 in a given year is the first week that contains at least one day in the new year. For example, January 1, 2000, is a Saturday. Using the default, the first week in that year (
W1.00) is the period from Sunday, December 26, 1999, through Saturday, January 1, 2000.
Using WEEKDAYSNEWYEAR, you can specify how many days of the year must be present in week 1 in that year. When you use WEEKDAYSNEWYEAR to specify that the first week in a year must contain two or more days, then the week of December 26, 1999, through January 1, 2000, is the last week in 1999 (
W53.99), and the week of January 2 through January 8 is the first week in the year 2000 (
WEEKDAYSNEWYEAR = days
INTEGER expression in the range 1 through 7 that indicates how many days in the year must be present in week 1 of that year. The default value for days is
The Effect of WEEKDAYSNEWYEAR
The following statements send a list of weeks with the associated ending dates for each of those weeks to the current outfile.
DEFINE week DIMENSION WEEK MAINTAIN week ADD '12 18 99' '1 15 00' weekdaysnewyear = 2 REPORT W 22 CONVERT(week date)
These statements produce the following output.
WEEK CONVERT(WEEK DATE) -------------- -------------------- W51.99 18DEC99 W52.99 25DEC99 W53.99 01JAN00 W1.00 08JAN00 W2.00 15JAN00
January 1, 2000, is a Saturday, so setting WEEKDAYSNEWYEAR to
2 causes the week from January 2 through January 8 to appear as