Performance problems in drill down - drill up macro's

[Former Member]

Hi all,

We have several planningbooks in which we want to view data on an aggregated level, and perform calculations at a detailed level. With macro functions check level, drill down and drill up it is possible to do these calculations at the lowest level, while an aggregated view is active in the planningview. Although it is very elaborative to create such a macro (find out which level is active, remember that level, drill down to the lowest level, perform calculation, drill up to the level that has been determined in first step) it works fine. But if several CVC's are part of the aggregated level, executing such a macro takes quite some time.

Are there people with same requirements? How did you solve it, and how is perfromance?

thanks in advance

Jean Vroemen

[Former Member]

it might be difficult to get a better system performance for this.... unless you want to increase ur processing power. As an SAP note mentions "The longer processing time required by the system is normal, and cannot be reduced. The drilldown you execute requires that an extremely complex application logic and intensive liveCache operation with high data volumes be used. Unfortunately, this is a time-consuming calculation process"

a couple of other things that you can just try

-->you can try to create POS aggregates at the level in which you will be doing the calculation.

this will ensure that the drill down stops at the right level and doesnt do an aggregation from the CVC level. There are some discussions on this in the forum

-->do not have unnecessary KF(hidden or otherwise) and auzilliary KF since the drill down will be over all KF

-->dont have long horizons, history, invisible or otherwise - just as much as you need

-->Check to make sure you dont go through level change or default macros when the drill up and drill down happens

--> Hardware setup

--> Try to build a business process that doesnt necessitate an interactive drill up and drill down. Maybe this can be done in the background. you probably can use the interactive mode to set a flag and do the calculations on exit and come back

or Build a process that doesnt necessitate too detailed drill downs and you dont have to load all CVCs at aggregate level

[srinivas_krishnamoorthy]

Not sure which version and SP you are on. There are a host of OSS notes on improving drill_down macro. Do a search on - drill_down macro performance in OSS. Some of them are consulting kind of notes as well. It might give you insight on this issue. Honestly, I would try to avoid using drill down or up macros in interactive mode. Instead have users drill down navigationally through the shuffler. Or try to explore a user-exit macro to do the equivalent.

[Former Member]

Hi,

We fixed the performance issue by ensuring that the selection id for the background planning job run has no wildcard entries. Populate the selection window with ranges of material or location, as the case may be and it should improve performance.

Regards

Vinod