Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Installation and Configuration Guide > Siebel Analytical Applications Metadata > Metadata Requirements for Sales Analytics Applications >

Performance

---

Siebel Sales Analytics uses the Siebel transactional database to provide real-time analytics capabilities. System performance must be carefully managed by using the various caching capabilities of both the Web Server and the Siebel Analytics Server and by using the optimization capabilities of their databases. Read Siebel Analytics Performance Tuning Guide before deploying Siebel Sales Analytics.

In addition to the performance tuning steps described, you can do two things to improve the overall performance of the Forecasting subject area:

• Archive forecasts in the data warehouse consistently.

  For instance, you archive each forecast one week after completion. By storing more forecasts in the data warehouse, you simultaneously improve the performance of the analytics queries and reduce the burden on the relational database.

  The Initialization Block variable ETLRunDateMinusInterval controls which forecasts are sought in the relational database and which forecasts are sought in the data warehouse. This variable looks for forecasts with dates that are some interval before the last ETL run date. For instance, if each forecast is stored one week after completion and an ETL is run each week, then it is guaranteed that any forecast two or more weeks old will be in the data warehouse, so the ETLRunDateMinusInterval should be set to ETLRunDate - 14 (days).

  The Siebel Analytics Server looks in the data warehouse only for those forecasts that are actually there, so care must be taken in determining this variable.

• Use the single currency forecast.

  By preconverting the forecast data into the data warehouse default currency, you remove the necessity for all forecast data to be currency-converted. This allows you to remove the joins and SQL required in the forecast metadata for currency conversion, thereby improving performance. See the Siebel Forecasting Guide for detailed instructions on how to establish and maintain single currency forecasts.

Bookshelf Home | Contents | Index | Search | PDF