Oracle Transactional Business Intelligence

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

OTBI Report Performance Issue

Received Response
496
Views
3
Comments

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):

Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    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,

  • Rank 6 - Analytics Lead

    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

  • Rank 5 - Community Champion

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.