Creating a 'block of 4 weeks' dimensions within a given date range in Master Calendar

[andymanu]

Hi Team,

Appreciate your feedback on below query.

I got a date range set an variables in the data load script. Refer below.

SET vStartDate='02/11/2020';
SET vEndDate='24/01/2021';

Need to create a dimension in Master Calendar to group the data records in to 4 week blocks as shown below;

New Dimensions with 4 weeks blocks

02/11/2020 - 29/11/2020

30/11/2020 - 27/12/2020

28/12/2020 - 24/01/2021

I got the other dimensions in Master Calendar such as, Week, Year, Month, Day, WeekDay, YearMonth etc...

Appreciate if you could help me to create this dimension to get my final intended outcome pls. Just wondering whether I can use the "floor" function to accomplish this.

Thank you in advance.

Kind regards,

Andy

[andymanu]

Hi All,

Sorry for certain wording I have used.

Since cannot change the posted question, my intention is to create a single dimension and incorporate it into the Master Calendar section. The values of the given dimension is depicted in the above table.

Appreciate your feedback.

Thank you.

Andy