Essbase @movsum function help

@movsum

Summary

Essbase @movsum function help

Content

We have an LTM (last twelve months) dynamic calc that is using the @movsum function. It appears to be working correctly until you hit the year 2017 where the calc is only pulling back data from 2017, it will not include data from 2016 when looking at 01/2017, 02/2017, or 03/2017.

The calculation is as follows:

@movsum(amount, 12, @children(All_Months));

All_Months is just a dimension with all months listed from 1993 forward.

The user provided a spreadsheet that had dates listed from 10/2015-03/2017. The calculation returns the correct value for all dates until you hit 2017 and it seems to ignore the 2016 data.