Skip to Content
author's profile photo Former Member
Former Member

Macro drill down and back up in demand planning

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Feb 13, 2014 at 05:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 14, 2014 at 02:13 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.