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

 Return to Index  

@Allocate...

February 2 2012 at 6:46 AM
No score for this post
 
from IP address 168.164.246.251


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:

FIX(@LEVMBRS("Period",0))
"Accnt_1"("Accnt_1"->"YearTotal" / 12);
ENDFIX

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   
 Copyright © 1999-2014 Network54. All rights reserved.   Terms of Use   Privacy Statement  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.