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

andymanu — Sat, 16 Nov 2024 17:23:26 GMT

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

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

andymanu — Tue, 16 Mar 2021 21:19:21 GMT

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

topic Re: Creating a 'block of 4 weeks' dimensions within a given date range in Master Calendar in App Development

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

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