Oracle Communities

Oracle Analytics and AI

Child Item

Delay in syncing data for OTBI real time usage subject area?

I Have developed an OTBI report (Analysis) to get the Audit data like usage of OTBI reports in last 6 months using OTBI Real time usage subject Area. but to test that I have ran some other OTBI reports, and I ran my analysis. but I couldn't see the record of report I ran for testing? Is there will be any delay for syncing of Data??

Find more posts tagged with

OBIEE

Analysis

OTBI

Accepted answers

GPOtimization

Have you tried to clear cache?

Advanced Techniques: Set Caching Options for Your Analysis

All comments

Asritha

Even running after some time continuously for 1-2 hrs , I could see the records of the reports I developed but not the report I Tested. Is that means delay will be different for different reports??

Can some someone please help me with thiss??

Thanks

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/67882#Comment_67882

Hi @Asritha,

Welcome to the Oracle Analytics Community.

As per the below Oracle documentation, it should be a Real Time Report and should bring the data instantly.

https://docs.oracle.com/en/cloud/saas/human-resources/25b/faohb/OTBI-Usage-Real-Time-SA-2.html#Description

Can you please try after clearing the browser & BI Cache to see if there's any betterment.

Hope this help.

Thank you.

RichardChan

double check your query, can you post it here as you should be able to see your report run

Riyaz Ali-Oracle

Check this:

OTBI Usage and Performance Subject Areas Reference

GPOtimization

Have you tried to clear cache?

Advanced Techniques: Set Caching Options for Your Analysis

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/25829/delay-in-syncing-data-for-otbi-real-time-usage-subject-area

Hi Asritha,

There should be no delay. Please check the comment below from Raghavendra:

Not All OTBI Analysis' Appear in Subject Area - OTBI Usage Real Time — Cloud Customer Connect

Also, please confirm if you are still facing the issue?

Thanks.

Asritha

Hi All,

This Issue got Resolved by enabling Bypass Oracle Analytics Presentation Services Cache and adding prefix SET VARIABLE DISABLE_CACHE_HIT=1; in advanced tab in Analysis.

Thanks Everyone.

GPOtimization

Great!