On-Demand: Performance Tuning Oracle's BI Applications

Learn about some of the key techniques you can use to take the BI Apps to performance levels you didn’t think were possible.


  • Part 1 - Introducing The Performance Layer
  • Part 2 - Building The Performance Layer
  • Part 3 - Mapping Into Oracle BI
  • Part 4 - Implementation Considerations
  • Part 5 - Summary / Q&A

The BI Apps from Oracle present customers with a nice head start to getting their BI environment up and running. But for many customers, their user community demands lighting-fast speeds while running dashboards, reports and ad-hoc queries. Learn about some of the key techniques you can use to take the BI Apps to performance levels you didn’t think were possible.

The discussion begins with a conceptual understanding of why performance problems can exist and the counteracting design considerations. Special attention will be paid to the concept of a Performance Layer, describing what it is, what it is comprised of and how to build it. The presentation includes several real world examples of the significant performance gains that can be had from a Performance Layer.

Join Jeff McQuigg from KPI Partners for this virtual event that discusses techniques that can be used to optimize performance of the Oracle BI Apps.

Objective 1: Learn about the concept of a performance layer and what is involved with building one.
Objective 2: Understand the most important steps to improve the performance of your system.

Speakers: Jeff McQuigg, Beer Lover & Oracle BI Guru, KPI Partners

Complete the form on the right to watch entire recording >>

Q&A Session:

01:10 - Should we use SNOWFLAKE models?
02:39 - Are there typical performance expectations?
03:32 - What is meant by: "The Performance Layer is 'Industry Standard'"?
04:26 - How would you extend this for Essbase?
05:24 - When should a Performance Layer fit into a deployment plan?
06:27 - Are there any Performance Layer "best practices" for conducting upgrades?
07:22 - Is there an optimal number of columns for a skinny dimension?
08:20 - How do these tuning tips apply when using Exadata?
08:56 - Can you use a skinny dimension with OBIEE 10g?
09:46 - Can you create a VIEW for a skinny dimension?
10:40 - Full and Incremental Loads?
11:46 - Do you recommend building Performance Layer tables with or SQL or ETL Tools (like Informatica)?
13:27 - Can you discuss replication as it relates to the Oracle BI Performance Layer?
14:35 - Performance Layer... Data Mart? Just Skinny Tables?