stevefromOZ (10/29/2014)
So, will there be a dimensional attribute that the user can select to inform us of the 'selected' period (eg month)? Or alternatively, will they need ot select a forecast from a list of FC's in a dimension?Assuming we can get one of the above, am guessing you'll likely want to use a calculated member (measure) and SCOPE. Something like
create/declare calc measure, set value = 0
use scope(limiting to selected FC member perhaps)
calc_measure = (months of actuals, measures.actuals) + (months of forecast, measures.forecast)
close scope
that sounds like the solution, although I haven't got a clue with MDX script. I'm going to have a read of the "stairway" when I get home tonight and see where that takes me...
The cut off date for the start of the forecast is held in a field in the dsv called Forecast Begin date, and is defined per forecast iteration.