Datamart calendar table sets up weekly periods to start on Mondays

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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

Resolution

The Clarity application uses the International Organization for Standardization (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 to the following rules:

1. 1. The first week of a year is the week that contains the first Thursday of the year.
   2. 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.
   3. 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.

Notes:

• 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.