Friday Jan 30, 2015

Essbase BSO Parallel Calculation and Calculator Cache

Essbase BSO parallel calculation utilizes calculator cache on a per thread basis. This post is to show the relationship between using parallel calculation and calculator cache.


 

[Read More]

Sunday Aug 14, 2011

OBIEE 11.1.1 - DISABLE_SUBREQUEST_CACHING

In NQSConfig.INI file, the parameter "DISABLE_SUBREQUEST_CACHING" default value is NO. Caching subrequests improves performance and the cache hit ratio, especially for queries that combine real-time and historical data. In some cases, however, you might disable subrequest caching, such as when other methods of query optimization provide better performance.