Why does the Datamart Calendar table set up the weekly periods to start on Mondays?

Document ID : KB000027248
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

The Datamart table that contains the calendar data (NBI_DIM_CALENDAR_TIME) sets up the weekly periods to start on Monday, while my time reporting periods have been configured to start on Sundays. Why and how can I change this?

Answer:

The application is using the ISO standard for a global date format where a week always starts on a Monday and ends on a Sunday. Currently, the application does not have a functionality that allows you to change the week format for the Datamart Calendar Table.

To support the ISO standard, the application returns the ISO week number. In the ISO standard, the year relating to an ISO week number can be different from the calendar year. A week always starts on a Monday and ends on a Sunday. Some years may have 53 weeks.

The week number is determined according the following rules:

The first week of a year is the week that contains the first Thursday of the year.

If January 1 falls on a Friday, Saturday, or Sunday, then the week including January 1 is the last week of the previous year, because most of the days in the week belong to the previous year.

If January 1 falls on a Monday, Tuesday, Wednesday, or Thursday, then the week is the first week of the new year, because most of the days in the week belong to the new year.

Additional Information:

ISO is the International Standards Organizations. They do not create standards but (as with ANSI) provide a means of verifying that a proposed standard has met certain requirements for due process, consensus, and other criteria by those developing the standard.

The NBI_DIM_CALENDAR_TIME table is updated when the "Datamart Extraction" job is successfully executed.

Reference TEC435612 : Datamart: Technical White Paper