List of OTBI inefficient Reports

Fongang

Summary

looking for was to monitor OTBI reports performance and Frequency of use

Content

Hi All,

I am looking for ways to monitor the performance of OTBI Reports in fussion cloud environment. We have BIP and OTBI reports that are running poorly and I wish to find out how I can do that. Admin session mager provides the cursor cache where I can see the OTBI report run-time, logs and path but this information is only held for a very short time in the production environment. 

Has anyone an idea on how i can get this information for a time period of over a month?

- Report name with path

- Runtime

- Execution time and date

 

Thanks

 

Kingsley

Version

R13 - 18B

Christian Berg -Oracle

The problem with OTBI is, that it lacks a lot of the features of the "real" OBI. Whether left out or just not exposed to you.

OBI has Usage Tracking for that exact purpose. It's a DB storage for everything you see in the "Manage Sessions" so it persists the information and you can use OBI itself to analyze what's happening.

Not really useful in terms of solving your issue, I know, but that's how it is.

Saresh-Oracle

hi,

Does this SRDC - Fusion Application OTBI Report Performance (Doc ID 2007833.1) help?

Regards,
Sareesh

 

Christian Berg -Oracle

The real log files for OTBI pods must be requested via an SR. He won't be able to get to them himself!

Fongang

Christian/ Saresh,

how helpful will the pod logs be in providing this information? I don't mind requesting it via SR if it will provide a solution to this issues.

 

Thanks

 

Kingsley

Christian Berg -Oracle

You better hope it does because that's pretty much the only angle of attack that exists. Period X-D

AshishERPCloud

Check if this link is helpful:

https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/2336-bi-catalog-component-audit-report-a-custom-report-to-identify-bip-report-execution-details

Kind Regards

Ashish