Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
For a dimension of type WEEK, the WEEKDAYSNEWYEAR option determines how many days of the new year there must be for a week to be identified as week 1 of the new year.
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 (W1.00
).
INTEGER
WEEKDAYSNEWYEAR = days
An 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 1
.
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 W1.00
.