Hi, there,

Background:

We intended to create a data warehouse in this project. The data
warehouse is solely used for planning. We have business plan, forecast
and actual. Key users will provide source data in Excel for upload to
the data warehouse in a monthly basis. Every upload is of twelve months
data. Eg. May is our actual, we will upload Jan~Dec. Jan~May are our
"actual" and June~Dec are so called "forecasts". When it comes to June
(actual), we will upload Jan~June as "actuals" and July~Dec as
"forecasts". Please note that only upload "actual" and "forecasts" are
calculated value.

What we will do is those actual months values, we are not going to
touch, instead we will calculate the values for forecasts based on
formulae. The formulae itself contain aggregated fields from other fact
table. Eg. A change in qty from a fact table must update the amt in
another fact table.

We intended to create a data warehouse and build a cube on the data
warehouse.
Any suggestion to implement such a solution?

Thank you.

Regards,
YH