My first attempt to design and build a forecasting cube. We forecast 12 month
out. The forecast is based on products and is produced once a month. So I
have a prod_dim and version_dim and forecast_fact.

prod_dim: prod_name prod_key
A 1
B 2
version_dim: version period version_key
04-05 04/05 1
04-05 05/05 ...
.... ... ...
04-05 03/06 12
05-05 05/05 13
05-05 06/05 14
forecast_fact: prod_key version_key forecast
1 1 100
1 2 60
...

Q1: I don't know how to apply the calendar dimension? Do I need a calendar
dimension? If not, how to compare the actual sales with forecast? The actual
sales can be a monthly figure.
Q2: The forecast quantity is really big at the top level of version
dimension. Is this normal for forecasting cube? Is there a special design to
handle this?

Thank you...