Skip to Content
Former Member
Jan 13, 2007 at 01:25 PM

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