Skip to Content
Former Member
Jul 23, 2007 at 10:40 PM

DRILL_DOWN( ) function macro in DP forecast


Hello Friends,

I am using certain planning/forecasting levels in demand planning. For example there are 5 planning levels/forecasting levels A, B, C, D, E (various characteristics). When planner carry out forecast at aggregate level in interactive planning and uses "Detail All" then forecast is disaggregated to lower levels depending upon the level at which original forecast was made. This is fine in interactive demand planning.

Challenge comes in when forecast is carried out in background. Now it us up to planner to select any level and forecast for that level. I wanted to write a macro using DRILL_DOWN( ) function. But I am not sure as to which aggregate level the selection for forecast was taken. Therefore not able to use DRILL_DOWN( ) function correctly.

Have you come across this kind of situation and solved it.

Thanks and Best Regards, Manoj