Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 23, 2007 at 11:29 PM

    Hi Manoj,

    When you run the forecast in interactive or in background, when data is saved, this data is automatically disaggregated you don't need to do a macro in order to disaggregate data.

    When you select Detail All, data is not being disaggregated, this data was disaggregated when you save it.

    You can test it. You can create an activity to run a forecast, then assign this activity to a mass process, here in the mass process you have to specify the aggregation level that you want to use to run the forecast.

    Then, you can enter to interactive planning and review the forecast in any level that you want, there must be a disaggregated forecast.

    I hope this can help you.



    Add comment
    10|10000 characters needed characters exceeded