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

Last updated on JULY 25, 2024

Applies to:

Purpose

This document covers performance topics and best practices for Oracle Business Intelligence Publisher (BIP) for Fusion Cloud Applications Release 21B and higher. Most of the recommendations are generic for Fusion Applications releases. Release specific topics will refer to exact version numbers.

Scope

With Oracle Business Intelligence Publisher (BIP) real time analytic reports, Web Services (WS) data extracts, Oracle Enterprise Scheduler (ESS) flexible schedules, and Oracle Business Intelligence Enterprise Edition (OBIEE) integration, business users have a powerful means for accessing, interpreting and analyzing real-time data in Oracle Fusion Cloud Applications (FA). Users can easily create sophisticated reports with various custom attributes, filters, join conditions, and analytic functions using every single construct offered by Oracle SQL and PL/SQL. Proper design of analytic reports and data integration extracts in BIP is required to ensuring maximum performance and scalability, and to minimum impact on Fusion Middleware and Database resources in FA.

The BIP reports performance can be affected by the following factors:

• Functional requirements for complex calculations and aggregations over large real-time data
• Complex Datamodel design, involving multiple datasets
• Complex SQL logic design of its dataset(s)
• Data security clauses, either explicitly coded in a SQL, or coming from VPD predicates
• Customizations and extensibility attributes
• Web services data extracts and their execution frequency
• Complex data formatting resulting in longer data generation
• Processed data volumes, especially for scheduled integration reports
• Data shape or volume changes that affect optimizer cardinalities estimates
• Changes, such as patches or upgrades, affecting physical data model
• Combination of the mentioned items above.

The attached White Paper will cover each topic in more detail, with examples and recommendations on how to improve the design and to achieve better performance. Many examples will refer to SQL coding options, database query patterns, and SQL query execution paths. The target audience is expected to know SQL basics and to be able to read and understand sample execution plans.

Note, that FA offers more BI tools in its technology stack:

• Oracle Transactional Business Intelligence (OTBI) for quick and convenient custom and ad-hoc BI analysis
• Oracle Business Intelligence Cloud Connector (BICC) for extracting data in CSV output and publishing to Oracle Universal Content Management (UCM) Server or Oracle Storage Service.

Carefully evaluate all offered BI tools and choose the right one to address your functional BI requirements. BI Publisher may not be the best tool for data extracts, as it has enforced memory guards. BICC does not have such guardrails, so it is the primary extraction tool in FA SaaS. Refer to OTBI and BICC Performance Recommendations White Paper published via Doc 2679006.1 for more details on OTBI and BICC usage and recommendations.

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.