Region Forecast Template

The Region Forecast template has the field values detailed in the Forecast Template Details table.

Forecast Template Details
Field Value
Data Source Services Forecast Live
Delete Obsolete Plan Data Selected
Output Data Source Services Forecast Plans
Rate Table Fixed Currency Exchange Rates
Template Category "Services Forecasting"

Your selection while creating the template using the Feature Console determines the column dimensions used.

Time Period Year and Month

If you selected the "Time period year and month" option in the Feature Console, your templates have the following structure:

  • Column dimensions:

    1. Time Period End Date (Year)
    2. Time Period End Date (Month)
    3. Revenue/Cost
  • Row dimensions:

    1. Region Level 01
    2. Level 1
    3. Level 3 ID
    4. Breakdown
  • Measure: Amount (Corporate Currency)

In addition, the Dataset Filters for Time Period Year and Month table details the predefined filters that the template has. The AND logic is applied to the filters.

Dataset Filters for Time Period Year and Month
Dimension Operator Value
Level 1 Equals Opportunities
Time Period End Date (Year) Equals  
Time Period End Date (Month) Equals  

Time Period Name

If you selected the "Time period name" option in the Feature Console, your templates have the following structure:

  • Column dimensions:

    1. Time Period
    2. Revenue/Cost
  • Row dimensions:

    1. Region Level 01
    2. Level 1
    3. Level 3 ID
    4. Breakdown
  • Measure: Amount (Corporate Currency)

In addition, the Dataset Filters for Time Period Name table details the predefined filters that the template has. The AND logic is applied to the filters.

Dataset Filters for Time Period Name
Dimension Operator Value
Level 1 Equals Opportunities
Time Period Equals  

Example

The Region Forecast Example table represents a region forecast created using the template and the "Time period year and month" option. The forecast is also the parent forecast for a project-level forecast.

Region Forecast Example
Time Period End Date (Year) 2027
Time Period End Date (Month) 01 02
Revenue/Cost Revenue Cost Revenue Cost
Hierarchy Amount (Corporate Currency) Amount (Corporate Currency) Amount (Corporate Currency) Amount (Corporate Currency)
 North America USD 28,527.78 USD 28,796.12 USD 39,179.17 USD 36,215.54
 Projects USD 12,605.00 USD 28,796.12 USD 10,605.00 USD 26,796.12
 Acme Company - Managed Services-Project Part 1 USD 12,605.00 USD 28,796.12 USD 10,605.00 USD 26,796.12
Child Scenario Total USD 12,605.00 USD 28,796.12 USD 10,605.00 USD 26,796.12
 Opportunities USD 15,922.78 USD 0 USD 28,574.17 USD 9,419.42
 Globex Corporation - Full FM (Net New) USD 15,922.78 USD 0 USD 28,574.17 USD 9,419.42
Scheduled USD 0 USD 0 USD 0.00 USD 0.00
Unscheduled USD 15,922.78 USD 0 USD 28,574.17 USD 9,419.42