Latest data changes not reflecting in OTBI report immediately

Question

Hi, We have GL drill down OTBI report. Latest changes to data not reflecting in this report immediately. For example if we post and journal it is taking some time to reflect in this OTBI report. How we can make report to show changes immediately

Thanks

Narasimha

RyanPasca1 · Answer

You can also resolve this by simply clearing your browser cache, logging out, and logging back in.

This is the easiest solution.

OTBI reports do appear to store data in the cache at the browser level.

Riyaz Ali-Oracle · Answer

Please try the below:

* Edit the analysis
* Click on Advanced Tab
* In the Prefix input box, add the following and click Apply and Save the analysis:

SET VARIABLE DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1;

Nathan CCC · Answer

Hi,

If in your "drill down OTBI report" if you are using the subject areas in the metadata repository database (RPD), so you have created an analysis in OTBI or you have created a report in OTBI with a data model with dataset with SQL data source "Oracle BIEE" or data set data source is an analysis in the catalog, then before setting this session variable DISABLE_CAHCE_HIT on your logical query, you can use page Manage Sessions https://fa-esxc-dev3-saasfaprod1.fa.ocs.oraclecloud.com/analytics/saw.dll?Sessions to View Log to see if your logical query DID in fact hit the middleware application server Oracle BI Server "cache" (getting stale data) or not (to send one or more physical sql get the latest data from the application database).

Oracle® Fusion Middleware

Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition

12c (12.2.1.3.0)

E80927-03 October 2018

About Session Variables

https://docs.oracle.com/middleware/12213/biee/BIEMG/GUID-F1204007-2846-425D-8BF1-A05CF153CA7B.htm