on 02-22-2011 10:04 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.