Dear All,
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.
| Fiscal Week | Month |
| 201920 | 1 Month |
| 201919 | 1 Month |
| 201918 | 1 Month |
| 201917 | 1 Month |
| 201916 | 2 Month |
| 201915 | 2 Month |
| 201914 | 2 Month |
| 201913 | 2 Month |
| 201912 | 3 Month |
| 201911 | 3 Month |
| 201910 | 3 Month |
| 201909 | 3 Month |
| 201908 | 3 Month |
| 201907 | 4 Month |
| 201906 | 4 Month |
| 201905 | 4 Month |
| 201904 | 4 Month |
| 201903 | 5 Month |
| 201902 | 5 Month |
| 201901 | 5 Month |
| 201900 | 5 Month |
| 201899 | 6 Month |
| 201898 | 6 Month |
| 201897 | 6 Month |
| 201896 | 6 Month |
| 201895 | 6 Month |
| 201894 | 7 Month |
| 201893 | 7 Month |
| 201892 | 7 Month |
| 201891 | 7 Month |
| 201890 | 8 Month |
| 201889 | 8 Month |
| 201888 | 8 Month |
| 201887 | 8 Month |
| 201886 | 9 Month |
| 201885 | 9 Month |
| 201884 | 9 Month |
| 201883 | 9 Month |
| 201882 | 9 Month |
| 201881 | 10 Month |
| 201880 | 10 Month |
| 201879 | 10 Month |
| 201878 | 10 Month |
| 201877 | 11 Month |
| 201876 | 11 Month |
| 201875 | 11 Month |
| 201874 | 11 Month |
| 201873 | 12 Month |
| 201872 | 12 Month |
| 201871 | 12 Month |
| 201870 | 12 Month |
| 201869 | 12 Month |
Thanks in advance
Steve
