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...

yes mate 🙂

My problem is that sales exist AFTER the historical forecasts begins so we need to ALWAYS show Forecast, and only include the sales up to the start of...

unless I'm misunderstanding your answer.

So, in September when we input the forecast (FC1) for the rest of the year, we have:

Sales Jan through Sept, then a forecast (called FC1) starting...

Not quite.

The history is contained in the Actuals which is one measure group. there is only one version of sales.

the forecast is revised monthly, so there are multiple forecasts,...

Thanks for the reply - I've worked it out. Little did I know, you can actually join a query to a query to pull out the data!

The query that...