Skip to Content
Author's profile photo Rahul Handa

Macro – Detailed Level Planning

In certain business requirements Managers expect that their team forecast numbers on the detailed levels. This means instead of forecasting on material number, forecast should be on material and location combination.

To achieve this we can have a macro which checks whether user has drilled to material and location for forecasting or not. If only material is selected in the selection window then row will be in a display mode else it will be in change mode. This could be AGG_LEVEL & ROW_INPUT functions.

In below example we have mentioned that if aggregated level is material and location then attributes of row will be input ready else display only.

Macro 1.JPG

Now if I select material and location in selection window then this would be input ready as this is at detailed level. If you have a single CVC for a material with one location then automatically it will open as input ready being the detailed level.

Macro 1.JPG

On the other hand if i select only material then this would be in display mode being aggregated level.

Macro 1.JPG

Now if we drill down to location level through header information settings and click either one location or details (all) this will be input ready.

Macro 1.JPG

This way we can make sure that users put their forecast on detailed level then on aggregated level.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Denitsa Dimitrova
      Denitsa Dimitrova

      Hello Rahul, 

      very good example, but currently I'm struggling with restricting input when 3 characteristics are selected - Location, SKU and Plan Customer.

      When I try to add 3 conditions with 2 ANDs - does not work.

      Can you give a suggestion?

      Thanks in advance!

      Denica