Disaggregation of calendar week to fiscal week
I have a requirement in which the customer has a Fiscal Week that starts on Thur and ends on a Wed. However, for our planning application, the users will plan on 0CALWEEK, and we need to derive Fiscal Week. For example, if a user enters in 100 for a Summation key figure for 0CALWEEK (Mon - Sun), we would need to proportion 3/7 to Fiscal Week 1 = 43, and then 4/7 or 57 to Fiscal Week 2. I think we can modify the 1st record record to read...
0CALWEEK FISCAL WK 0AMOUNT
1 1 43
...and generate a new record for FW 2 to read...
1 2 57
We can create a function of type Exit that can do a lookup to the Factory calendar to obtain the number of working days in a particular calendar week in order to proportion the number of working days.
I can also think of creating a Distribution function to distribute to Fiscal Week perhaps based on historical data as another way to generate the Fiscal Week #2 record.
Has anyone else come across the need to split records like this? If so, then what approach did you take to solve the problem?
Edited by: Steven Wisz on Sep 22, 2008 3:37 PM