|Bookshelf Home | Contents | Index | PDF|
The Auto Forecast Search Spec and the Associate Search Spec can vary from one forecast series to another, and can 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:
In this example, the end user can manually copy into the forecast any revenue record with a Revenue Type 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.
Rollup Search Spec is used in scenarios where the History View Date and History Edit Date fields are specified in the dates for the forecast series. If when rolling up the forecasted revenue, the end user wants to include only those revenues having a close date between the specified Start Date and End Date of the forecast series, the administrator must define the following Rollup Search Spec:
Table 8 shows some common search specs.
NOTE: Test the search spec before deploying the forecast. To test the search 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.
|Siebel Forecasting Guide||Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices.|