Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Latest data changes not reflecting in OTBI report immediately

Received Response
510
Views
4
Comments
Narasimha Raju
Narasimha Raju Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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

Tagged:

Answers

  • Rich Merkel
    Rich Merkel Rank 6 - Analytics Lead

    Try adding this in prefix

    SET VARIABLE DISABLE_CACHE_HIT=1;

    Under advanced tab, do similar, then click apply sql.

    I have had good luck in the past, but if not I have advised to just close down web browser and restart that usually gets rid of any caching in the session.

    image.png


  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Mar 12, 2024 9:44AM

    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

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead

    Please try the below:

    1. Edit the analysis
    2. Click on Advanced Tab
    3. 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;
  • RyanPasca1
    RyanPasca1 Rank 2 - Community Beginner

    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.