Skip to Content
0
Former Member
Feb 17, 2009 at 04:07 AM

How to create planning book macros having different time bucket profile?

50 Views

Dear Experts

We have a problem in our project. Our data view have a short time bucket profile (13 weeks) which is used for Deployment whereas our SNP Planning is for 104 weeks. The thing is when running real time deployment for a shorter time period (as Heuristics is run to create new STRs in real-time deployment), safety stock is planned only for 13 weeks horizon which entails having zero STR at the end of the planning horizon because there is no safety stock calculated by DRP data view macros.

We tried to create macro in planning book but planning book somehow chooses a time bucket profile of one of the data views and other data views having different time bucket profile does not see the macros in the planning book.

So actually what we need is safety stock macro to run for 104 weeks without extending data view time bucket as deployment planning takes place only for 13 weeks. How can we do this?

Thanks a lot for your help!

Sisi