How to distribute Quantity posted against a week(s) of 4-4-5 into equal amounts of a period

[SP9]

Hi Experts,

We are getting total inventory from source system into one of the weeks of a period. We need to divide that equally into all weeks of a period.

The weekly planning is turned on the Date dimension with 4-4-5 pattern. Fiscal Calendar is turned on. P01 Week1 is starting on Jan 1st 2024, with Monday as the starting of the week, as shown below the 26 weeks of the Date dimension. 

For example, the data is coming weekly to current period and for the next 18 preiods, the data is coming at montly but posted against one of the weeks.

For the current periods weeks, we shouldn't redistribute it. For the next period onwards, depending on the number of weeks in that period (4-4-5), we should get the value redistributed equally among the weeks of that period. 

So, for WK8, the data got posted as 10,000. As Wk8 belogs to period 3, and as per 4-4-5 pattern, period 3 contains 5 weeks, hence the each week of Period3, should get 2000. that is: 10,000 / 5. This should be happening dynamically. If a second date dimension is needed in the model, definitely fine. Or if a differnt account needs to be created where the distributed values would be stored, that's fine too. We are using measure based model, with one measure: ProdPlanQty. If additional measure: ProdPlanWkly is needed to achieve this, that's also fine. Thanks in advance. 

Best Regards,

SP