Bookshelf Home | Contents | Index | Search | PDF |
Siebel Forecasting Guide > Forecasting Setup >
Creating Search Specs for Forecast Series (Administrator)
The following section explains how to build an Auto Forecast Search Spec and an Associate Search Spec.
Auto Forecast Search Spec and Associate Search Spec
The Auto Forecast Search Spec determines which revenue line items are automatically copied into the forecast when it is created. The Associate Search Spec determines which revenue line items can be manually added to the forecast by the sales representative after the forecast has been created. The Auto Forecast Search Spec and the Associate Search Spec can vary from one forecast series to another, and may be based on revenue type, revenue class, probability, or any other field on the revenue record. The end user sees the results of the Associate Search Spec displayed as a list of records in the Add New Records pop-up on the Forecast Details form.
The Auto Forecast Search Spec uses the same syntax and grammar that the Associated Search Spec uses. However, it is usually more restrictive in scope. For example, you can create a forecast series with the following search specifications:
Associate Search Spec: [Revenue Type] = 'Shipped' or [Revenue Type] = 'Booked'
Auto Forecast Search Spec: ([Revenue Type] = 'Shipped' or [Revenue Type] = 'Booked') and [Committed] = 'Y'
In this example, the end user can manually copy into the forecast any revenue record with a Revenue Class of Shipped or Booked, whether it is committed or not. However, the automatically included forecast details only include revenue records that were actually marked as committed.
As in this example, typically the Associate Search Spec is slightly less restrictive than the Auto Forecast Search Spec, allowing end users to copy into their forecast some revenue records that did not meet the more restrictive Auto Forecast Search Spec criteria.
Table 4 shows some common search specs.
NOTE: Test the search spec before deploying the forecast. To test the spec, navigate to the Revenues screen and create a new query. Type or paste the exact search spec into the Description field in the query and then run the query to see if it delivers the correct results.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Forecasting Guide Published: 18 April 2003 |