Switching to a Monday-start retail calendar

Some businesses want to use the NRF 4-5-4 calendar, but with weeks starting on a Monday rather than on a Sunday.

If you’re one of these businesses and are an Enterprise user, you can make an update in your custom code repository that will use a specialized calendar script that uses a Monday start date for the week.

Here’s how you would do that:

Step 1:
Assuming you already have access to your custom SQL code repository, navigate to it in GitHub.

Step 2:
Open the daily_incremental.yml file in edit mode.

Step 3:
Find the following script reference in the file:
github://platform-sql-shared/scripts/base/0100_initialization/0120_INI_BAS_retail_calendar.sql

Step 4:
Replace it with the following script reference, making sure not to change any spacing or indentation:
github://platform-sql-internal/scripts/templates/calendar/0070_INI_initialize_retail_calendar_monday_start.sql

Step 5:
Commit the change to the master branch, and you’re done.

The next time your daily workflow runs, all of the retail-calendar-based dimensions will reflect the Monday start date.