Essbase ASO Calculation Query

Hi Gurus,

I am trying to create a script through EPM Calc Manager for an Essbase ASO cube.

The requirement is to seed the Beginning Balance of the future year with last year's data.

Something like : BegBalance-> FutureYear = BegBalance-> CurrentYear + (M1+M2+........)-> FutureYear.

Is this possbile to achieve the calculation in ASO cube via the Calc Manager Business rules.

When I try to mimic something similar to this, it throws the below error :

Formula Source:

All the required dimensions should be populated with values.

Please provide values for these dimensions

We do have an work-around via DataExport and Import but the process is not scalable and time - consuming.