I've created some script logic in SP4. The good news is that it works, but the bad news is that it's not as fast as I would like, especially since it will reside in default logic. That being said, the trick with this logic is that anytime data is loaded for certain accounts, it needs to recalculate values from the first period of the budget, push a value to the next sequential period, calculate again at that period, push a value to the next period again, etc...
So, I've got some *WHEN's, *LOOKUP's, and *COMMIT's to get the job done, but I feel like I have too many commits to have decent performance. In the SQL version, I would have used *GO's or other commands to shorten the code and/or do this quicker, but I don't feel like I have as many options in Netweaver SP4. Anything I'm missing out there folks?
From a performance perspective there are at least two items you might consider:
1. Are there any MDX based commands in your code? The processing of MDX based commands is known to be significantly slower than pure SQL based commands. If you have and code using [dimension].[member] then you might consider rewriting those portions using SQL techniques.
2. For very complex script logic code, you might consider the option of replacing the script with a BADI call. ABAP can be extremely efficient, however the downside is you will need to create and maintain a custom program.