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
from IP address

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   

  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 - Please email hypess (at), if you have any questions/feedback/issues.