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.