OBI Server is not mere SQL Generator:
SQL is generated by Oracle BI Server against the data sources using the data source connection, information from the repository, and database-specific parameters stored in a DBFeatures.ini file. Thus, Oracle BI Server is not just a SQL generator. It determines the best source and the optimal way to access data. In some cases, Oracle BI Server takes on operations that are more efficient for it to perform rather than the host data source.
Purging BI Server Cache:
• BI Server cache is stored in the directory: d:\Oracle\OracleBIData\cache • Create the script called PurgeBICache.sql with following command:
Call SAPurgeAllCache ();
• Run the following command to invoke the script and clear the cache: nqcmd -d AnalyticsWeb -u Administrator -p Administrator -s PurgeBICache.sql -o purge_clear.log
• This will clear all the BI server cache entries for all the users.
Purging BI Presentation Server Cache:
Presentation cache stores the finished report output in the presentation server. This is different from BI server cache. BI server could be leveraged by multiple users and reports depending on whether they are accessing similar or subset of the cached data, though from a different reports.
Presentation cache is report specific and user specific cache entries residing in the D:\OracleBIData\tmp\ folder.
The expiry of this entry can be governed by following instance-config.xml file in <
CacheMinExpireMinutes Default 10
CacheMaxExpireMinutes Default 15
