Set Limits on Essbase Query Execution Time

Slow execution of Oracle Smart View for Office queries can make other activities in the environment slower and drastically increase the CPU utilization, leading to slow performance. If you identify that long running queries are causing performance degradation, consider setting limits on the maximum time allocated for query processing.

To limit Oracle Essbase query processing time, run the setEssbaseQryGovExecTime EPM Automate command.