This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  


February 2 2012 at 6:46 AM
Score 1.0 (1 person)
Charl du Toit 
from IP address

Response to @Allocate - help needed

@ALLOCATE and its infamous cousin @MDALLOCATE works, but I find it works quite slowly, and prefer to write my own allocation logic. So in your simple case, I would use something like the following in a calc script:

"Accnt_1"("Accnt_1"->"YearTotal" / 12);

So no need for 12 lines, one per month. If you start making clever use of @PARENTVAL and @ANCESTVAL you can get quite creative with your allocations.

However for very complex allocations @ALLOCATE and @MDALLOCATE does offer some neat tricks to do a lot in a single line of code, just be wary of the performance.

Scoring disabled. You must be logged in to score posts.Respond to this message   

RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.