OTBI Report Performance Issue

Question

Summary:

Customer facing performance issue with the reports developed using OTBI

Content (required):

Customer developed some of the reports using OTBI reporting tool where the report parameters and report filters are dependent on the DFF value. Will this have an impact on the performance ?

Also we observed some of the reports customer is using multiple subject areas in their reports which are causing the performance issues in their reports.

Any suggestions on this are highly appreciated.

Version (include the version you are using, if applicable):

23A

Code Snippet (add any code snippets that support your topic, if applicable):

Sahithi Kolasani-Oracle · Answer

We need to check the reports running slow and analyze case by case basis.

If we are creating reports using multiple subject areas and not restricting data to specific criteria, performance is going to be slow.

If the reports are analytical in nature which require cross-functional capabilities, customer can be suggested with ADW and OAC kind of reporting platform which will be must faster as it is best suited for analytical reporting.

Praveen Kumar Akkala-Oracle · Answer

Hi @Praveen Gollu-Oracle,

Please review teh below documents on how to handle the performance issues in OTBI.

Oracle Fusion Transactional Business Intelligence and BI Cloud Connector Performance Recommendations (Doc ID 2679006.1)

Oracle Business Intelligence Publisher Performance Recommendations for Fusion Cloud Applications (Doc ID 2800118.1)

Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers (Doc ID 2731495.1)

Thanks,

Praveen

Bhaskar Konar · Answer

Hi @Praveen Gollu-Oracle,

You need to perform various steps. Please fine below a document which might be useful for you.

Document 1999456.1 (oracle.com)

Hope this help.

Cheers,