Current Playlist
Comin’ at ya straight outta the BI Apps Corner guest DJ Bec is here to throw down some performance tips on the 1’s and 2’s we know as the Data warehouse and BI stack. Just because you have a hammer doesn't make every issue a nail. So don’t sweat those slow loads and get ready to bounce, shimmie and shake that database.
BECKY WAGNER
The DJ Bec Curated Playlist
Database/SQL Query
1. Database Tuning–Effective Tips for Database Performance Tuning Neeraj Mishra |
2. Database Performance Tuning Guide Oracle |
3. 32 Tips for Oracle SQL Query Writing and Performance Tuning Ranjan Gupta |
Weblogic
OBIEE
Ahmed Awan |
8. New OTN Article - OBIEE Performance Analytics: Analysing the Impact of Suboptimal Design Robin Moffatt |
ODI
9. Performance Tuning Oracle Data Integrator Sharath Venkataranga |
Devemp.com |
11. ODI 11g - Loading More Files Faster David Allan |
OBIA
12. Oracle Business Intelligence Applications Version 11g Performance Recommendations Pavel Buynitsky (Oracle sign-in may be required, PDF) |
Previous Playlists
In this first-ever playlist compilation from DJ Harms, we’re gonna kick it old-school. We’re paying homage to that godfather of OBIEE hip-hop: everyone’s favorite metadata thumpin’, ever-present, and seemingly-never-changing three-paned, Windows-only(!?) program client that you have to read from right to left! The OBIEE REPOSITORY, otherwise known simply among its friends by its shortened moniker: "The RPD.” Let’s bounce to the tunes of this venerable BI legend.
JEREMY HARMS
The DJ Harms Curated Playlist
"The RPD Essentials"
1. 20 Golden Rules for the OBIEE 11g RPD Anthony Heljula |
2. Creating a Repository Using the Oracle BI Administration Tool (11.1.1.7) Oracle by Example (OBE) Tutorials |
3. Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition |
4. Oracle BI EE 11g – Lookup Tables – Sparse and Dense Lookups Venkatakrishnan “Venkat" Janakiraman |
5. OBIEE 11g Data Modeling Best Practices Mark Rittman at OOW 2010 |
6. When Fact Tables Do Not Join to All Dimension Tables The Legend Kurt Wolff |
Jeff McQuigg |
8. The Single Most Important Thing to Know About the OBI RPD Jeff McQuigg |
9. BI 11g Design Best Practices and Performance Tuning Nicolas Barasz and Paul Benedict of CEAL |
10. Using OBIEE for Reporting Directly Against Operational Systems Steve Devine |
11. Using OBIEE Against Transactional Schemas (five-part series!) Stewart Bryson |
12. Oracle Business Intelligence 11g Developers Guide (the quintessential book) Mark Rittman |