VEC_SUM macro

[Former Member]

Morning.

we are trying to improve the performance of a DP macro. we are trying to add the values of two KeyFigures over a period of two years. The macro runs for a total of 157000 CVCs so the current processing time is close to 8 hours. We are thinking of using VEC_SUM functionality to improve the performance (plus some selection criteria.

The problem is that we cannot get the VEC_SUM macro to work. have pasted the macro below. Any indicators as to why it is not working will be highly appreciated.

Macro :

Macro Calculate Corrected History

Step : Calculate corrected History ( 78 Iterations : W08.2011;W33.2012)

Area: Corrected Forecast (W 08.2011) =

VEC_SUM(

Area : [$Selected Forecast (w 08.2011); $Selected Forecast (w 33.2011)]

;

Area : [$Corrections (w 08.2011); $Corrections(w 33.2011)]

)

Cheers,

KB

[former_member182607]

Karthik,

I am surprised 157000 CVCs take 8 hours..normally evry second 100-120 macros should be executed. I am running 186000 CVCs in 27 minutes...check with your basis team

Subash