Using parallel computing

OLAP can take advantage of multi-core computing. Requests from different users are executed in parallel on different cores.

The assignment of the requests to the cores is done by the operating system. For example, on a four core system, four independent requests from four different users can be executed at the same time with little slowdown.

While a standard request is executed sequentially on one processor core, OLAP can distribute some calculation requests to multiple cores. This functionality is used especially when many values are expected during an aggregation. In this case, the workload of a single request is distributed to multiple threads. Each thread can be executed on another core. This behavior can be configured with the Multi-thread calculation option on the Database Performance dashboard.

See "Database performance options" in the d/EPM Administration section.