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.
Last month, Jeff McQuigg presented a virtual event that discussed techniques that can be used to optimize performance of the Oracle BI Apps. 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 begans with a conceptual understanding of why performance problems can exist and the counteracting design considerations. Special attention was paid to the concept of a Performance Layer, describing what it is, what it is comprised of and how to build it. The presentation included several real world examples of the significant performance gains that can be had from a Performance Layer.
Click here to access to the entire on-demand recording and learn about some of the key techniques you can use to take the BI Apps to performance levels you didn’t think were possible.
An abbreviated preview is available below.
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?