Issue with @xrange function when used with planning application.

@xrange

Summary

Issue with @xrange function when used with planning application.

Content

There is a requirement to copy Actual scenario monthly data of 3 years to next month over 3 year period.

Ex:                                         Jan    Feb  Mar   Apr

Actual                                       1      2        3      

ActualPrevMnth                               1         2        3   

ActualPrevMnth is Dynamic calc with formula @Prior("Actual",1,@Xrange("FY17"->"Jan", "FY19"->"Dec"));

The results are good as long as its essbase application.

However when using with planning application the results are wrong. (Period is having default member BegBalance)

XRANGE is pulling the BegBalance along with months which is giving wrong results for Jan month.

Is there a way to ignore BegBalance from XRANGE completely so that Dec ->FY17 is copied to Jan FY18?