Measures to be implemented in a Model

Post Reply
sivan307
Posts: 28
Joined: Wed Sep 01, 2010 2:15 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Measures to be implemented in a Model

Post by sivan307 »

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
Post Reply