Best Practices for OTBI Reports Handling Large Data Volumes

Summary:

Hi everyone,

I’m looking for recommendations and best practices for developing OTBI reports that need to handle large amounts of data.

Is there a recommended step-by-step process for structuring these reports?

Do you have suggestions for writing queries efficiently?

Are there any portals, visual resources, or tools (in addition to the standard Oracle documentation) where I can directly consult the entity-relationship model of the tables used in OTBI?

What practices do you suggest to avoid performance issues, row limits, or errors when exporting the data?

I appreciate any advice, experience, or references (guides, examples, documentation) you can share on how to optimize and structure these reports for large data volumes.