Macro drill down and back up in demand planning

[Former Member]

Hello everybody,

I have the following problem:

In a macro I perform a first step drilling down on a selection.

Then on the detailed level I check and save the status of a key figure whether it is fixed or not.

In the last step I drill back up.

Perfomring these three steps in one macro, nothing is done.

However when I run these steps in seperate macros, the desired functionality is met.

Does anybody know the cause of this problem?

Thank you very much in advance for your answers.

Best regards

Mitch

[satish_waghmare3]

Hello Mitch,

I had worked on somewhat similar requirement in the past.  I had created two macros with below logic:

Drill Down Macro will set the variable value if aggregation level matches with desired level and then it will do drilldown to specific level.

And 2nd Macro-Drill Up Macro will check value of variable then Drill up to that specified level and reset the value in variable.

I remember following were the functions which were used. You need to build logic based on IF Conditioning.

LAYOUTVARIABLE( 'FLAG' ) = 'X'

LAYOUTVARIABLE_SET( 'FLAG' ; '_' )

LAYOUTVARIABLE_SET( 'FLAG' ; 'X' )

DRILL_DOWN( 'ZLEVEL' ; 'INTERNAL' ) = 1

DRILL_UP( 'ZLEVEL' ; 'INTERNAL' ) = 1

Other two functions which can come handy here :  AGG_LEVEL and DET_LEVEL

Also as suggested by other experts, it is better to use separate Action Box for Drill Down and Drill Up.

Hope this will give you some insight.

Thank you

Satish Waghmare

[jagannadhb]

Dear Mitch,

Based on your description, I feel that there is a problem with "Loop" in iterations. If you can share a screenshot of your Macro, we can have a better understanding.

It is advisable (performance wise) to have separate action steps for Drill Down and Drill up.

You can have your macro like this:

ACTION: DRILL DOWN

CONDITION: ITERATION

ACTION: DRILL UP