Bookshelf v7.5: Siebel Analytics

You can take several actions to improve the performance of the Siebel Analytics server. Table 1 summarizes the principal actions.

Table 1. Performance Improvements for Siebel Analytics
Action	Description
Enable Query Caching	Verify that query caching is enabled.
Create Aggregates	Create aggregates that the Siebel Analytics server can use to rewrite queries.
Evaluate Design	Make your logical objects efficient. For example, divide large dimension into a set of smaller ones.
Evaluate Reports	Evaluate your reports and optimize. For example, look at frequently run Dashboard reports and make sure that only the columns required by the reports are selected. Remove all superfluous columns.
Review Configuration	Verify that the configuration of Siebel Analytics matches your actual workload. For example, configure a pool sufficient to support connections, case sensitive character comparisons, driving tables within queries, and query caching.

These are the most common actions you can take to improve the performance of the Siebel Analytics server.