Step-by-Step Transformer  7.5.0
Additional Reference >

Partial and Extra Weeks

Partial Weeks

If your time dimension contains a Week level in a calendar year, the day of the week that the year ends on may not coincide with end of the week. (A lunar week always ends at the end of the week.) For example, the last day of 2000 is a Sunday. By using the Partial Weeks option, you can specify how to shift or split up the last week in the Week or the lowest date level in your time dimension.

The following example shows what would happen to a Sunday-to-Saturday week that spans December 2000 and January 2001.

Dec. 2000/Jan. 2001

 S  M  T  W  T  F  S
31  1  2  3  4  5  6

Setting

Description

Example (Dec. 2000/Jan. 2001)

First Period

Places the week into the period in which it begins.

Period: Dec. 2000

S M T W T F S

31 1 2 3 4 5 6

Last Period

Places the week into the period in which it ends.

Period: Jan. 2001

S M T W T F S

31 1 2 3 4 5 6

Largest Period

Places the week into the month having the greatest number of days in that week.

Period Jan. 2001

S M T W T F S

31 1 2 3 4 5 6

Always Split

Creates two distinct partial weeks by splitting the spanning week between the two periods. On the dimension diagram, both weeks are displayed.

Period: Dec. 2000

S M T W T F S

31

Period: Jan. 2001

S M T W T F S

1 2 3 4 5 6

Split > 1 Day

Splits the spanning week between the two periods, provided that each period contains at least two days. Otherwise, places the week into the period to which most of the days belong.

Period: Jan. 2001

S M T W T F S

31 1 2 3 4 5 6

Extra Weeks

When you use lunar time periods, a year contains 52 weeks of 7 days each, yielding 364 days. This is either one or two days less than the calendar year of 365 days or 366 days (for a leap year). Eventually, after a few calendar years, the number of "remainder" days begins to accumulate. Transformer can use these days to create an extra week category, and re-synchronize. This ensures that the lunar year remains within the boundaries of the calendar year, plus or minus the Add an Extra Week setting on the Drill Category property sheet.