Hi All:
I am creating a Revenue Forecasting Model with different dimensions. I have a measure dimension with 12 different measures. Each measure is calculated using a rule. Now I have a Scenario dimension that will have different scenarios like Actual Periods, Budget periods, Forecasting, etc. Now when I create a revenue forecasting cube using these dims, we want to load the data based on the scenario selected. Now when I choose actuals, I want to load the measure values from another cube called Summary cube. Also I want to write rules for the Budget periods. I need some direction in achieving this task.
As for the Scenario dimension these are the details-
Actuals : Only holds historical data.
Budget : This is frozen plan for the year which is used for variance analysis
Forecast: re-projected on a monthly basis based upon the latest actuals.
Please help.
Thanks,
Sivan