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

Drilldown and calc in macro


We have a setup like this:

Keyfig stat forecast A

Keyfig manual forecast B

Keyfig result C

The logic is that if there is manual forecast then that takes precedence over the stat forecast. We'd like to calculate the result online.

The issue appears whenever people do a manual update on detailed level, and then drill up to see the aggregated result.

In these cases you can't really see the aggregated result since for it to be calculated you need to calculate it for the entire structure of CVCs (considering all the cvcs that has a manual forecast and all the ones where the result is based on the stat forecast).

This can easily be done with a batchjob run on detailed level for the relevant selection. But this is not very elegant and "online" for users.

My question is if there is a way to do it with a macro from a planning book? Could it be possible to make a macro that could be activated via a button that would execute a calculation for all CVCs in the current selection?

I guess what im really asking is if i can replicate the batch functionality in a planning book macro.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 07:44 AM

    Hi Simon

    If I am getting your requirement correct, you want to dis aggregate/aggregate at the lowest level or at the highest level and do your calculation.

    I think for this requirement, you can use a collective macro and assign a button to it.

    In the collective macro, you can use the function DRILL_DOWN and DRILL_UP, to drill down to the needed characteristics.

    Between the 2 steps, you can perform the necessary calculation and do the drill up/down, as required.

    But please note that executing a collective macro interactively may be performance intensive. Hence please test the development exhaustively in the test environment before moving it to production system.

    Thanks, Sandeep

    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.