I has a dimension which is fiscal week. The fiscal week will update on daily basic. I want to group the week in the sequence of 4-4-5 into month, which cover total of 12 months. How this can be done in load script?
Below the example which this week is 201920, I need the Month grouping dimension.
I think I would use for this an extra 4-4-5 calendar parallel to your fiscal calendar (and probably a "normal" one). How it might be created, see: Non-Gregorian-calendars.
