Custom Time Dimension / Supply Planning on a daily basis
For a client of us we're looking into setting up a Supply Planning model where planners have the ability to plan with a telescopic view. Meaning they're able to simultaneously plan on a daily & weekly basis.
Ideally we would work with the standard time but as weekends can not be taken into account we're looking into doing this with custom time dimensions.
To do this the idea is to create a custom time hierarchy where weekdays roll up into weeks. By doing this we're conceptually already running into some technical issues.
1. How to still use time and date functions such as MOVINGSUM & TIMESUM with a custom time dimension?
2. Is there a way to use the Time Summary methods 'Opening Balance' & 'Closing Balance' with this custom made time hierarchy? This is necessary for line items such as beginning & ending inventory.
3. If we would still use the Anaplan standard time dimension, is there a clean way to consistently ignore the weekenddays in all line items on time?
Thanks in advance for your advice, any input is welcome!
If you know of any use case that has a functional Supply Planning model in days I would be excited to reach out.