i want to build up a rolling Forecast modell for monthly data entry and adjustments.
I have 2 Cubes. One with actuals and one with forecast (incl. Version).
Now i want to select a time-frame for the past month (like 01-03) and a Forecast-Version (like April) an fill the Forecast-Cube with actuals from the previous month and with the forecast from a previos Version (March).
What is the best way to solve this?