Skip to Content
avatar image
Former Member

Macro Execution level

Hi APO users .....

I have one doubt on how to make a macro execute at only one particular level. i.e.the most detailed level. The macro ( which is a default maco )should not get executed on an aggregated level for even one characteristic. i.e. Even if the user data selection is at any level in the interactive planning book.... What it should do actually is Drill down for all characteristics on the detailed levels and execute itself rather than executing at a higher level and then performing disaggregation and thus screwing up the existing data at the detailed levels.

What I am planning to do is use a Drill down functions in the macro for all the characteristics and then perform the desired clculations. I hope it works... Any ideas .... since I am going to work on Production server I just want to confirm the validity of my approach before going ahead

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 13, 2007 at 05:13 PM

    You can always check whether is view is at aggregation level using AGG_LEVEL function. Eg. AGG_LEVEL( '9ALOCNO' ) = 1 , indicates that the current view is not at the detailed level for Location characteristics. You “OR” to combine with the other characteristics you have in the planning object structure. We have also faced a similar issue. We solved using a background job which executes the macro at the detailed level.


    Thanks for rewarding points if this is helpful

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks a lot Dude ....

      That solves half of my problem for some macros ... But what if I have to execute the macro even if the user is at the aggregated level in the interactive planning book but only after getting drilled down for each and every characteristic. By this I want to prevent the untouched data from getting disaggagregated to lower levels when the macro is executed at a higher level. I am planning to use Drill_Down() function on each characteristics before performing the calculations. By this way I suppose the data at the detailed levels will remain the same as it was before the macro execution for those period buckets which the user didnt touch at all before executing the macro.

      I hope drill_down() works !