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

Rolling 12 Months Across Years

August 2 2012 at 2:56 PM
No score for this post
Edward 
from IP address 216.58.241.102

Has anyone ever come up with a solution to do a rolling 12 months sum or average that crosses years where the period and years are in different dimensions? The only thing I have come up with was a dynamic calc where the subvars set the end point and save off history. Would need this to be more like DTS. I suppose a CDF is in order.

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

  1. Check out the @XRANGE function - Cameron Lackpour on Aug 2, 2012, 3:34 PM
    1. Thanks Cameron! - Edward on Aug 6, 2012, 1:58 PM
     
  2. Re: Rolling 12 months - Stuart Game on Aug 2, 2012, 6:04 PM
    1. Very Nice, Thanks Stuart - Edward on Aug 6, 2012, 1:58 PM
     

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.