Oracle BI Suite EE 10g R4Dashboard, Answers and Metadata Management

On-Site Training: $2,900 per day; Up To 10 studentsDuration: 4 DaysCourse Code: OR8153

Course Description

Deliver meaningful real-time metrics, measurements and facts to your business users when you master the components in Oracle's Business Intelligence Enterprise Edition (OBIEE). Our instructor-led courses cover the key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts and produce reporting. Concentration is spent on how the tool will work with the data repository design and best practices to ensure a successful dashboard implementation.


Student should have a basic level of SQL and a good understanding of business analysis concepts within their Industry.

Course Topics

Oracle BI Admin Repository

  • Business Intelligence 101 Concepts
  • Physical Repository Design
  • Metadata Layer Design
  • Building Presentation layer
  • Importing data sources
  • Setting up connection pool properties
  • Defining keys and joins
  • Creating alias and select tables
  • Dimensions, Facts and Measures Overview
  • Aggregates
  • Repository Variables
  • Time Series Data
  • Dimension Hierarchies and Level-Based Measures
  • Calculations on Fact Tables
  • Oracle BI Security Goals
  • Checking repository consistency

Oracle BI Dashboard /Answers

  • Dashboard Fundamentals
  • Dash Board Creation and Modification
  • Dash boarding and Navigation
  • Layout Concepts and Best Practices
  • Subject Areas
  • Navigation links
  • Prompts
  • View Types
  • Column Selectors
  • Drill Down and Drill Out
  • Filtering requests
  • Formatting results
  • Compound Layout / Views
  • Pivot Tables
  • Analytical Formulas
  • Rank, Lead, Lag, TopN, Rolling
  • Adding Text, Folders, Guided Navigation Links
  • Briefing Book Navigation Links
  • Controlling Drill Down Display
  • Creating and modifying requests
  • Gauges
  • Charts
  • Bubble Chart
  • Time series Chart
  • Executing Direct Database Requests
  • Building iBots
  • Styles / Skins
  • Microsoft download
  • Advance SQL Clauses
  • Folder / Tab Best Practices
  • BI Publisher Integration
  • Catalog
  • Global Filters
  • View Selectors
  • Column Selectors
  • Legends
  • Narrative
  • Ticker
  • My Dashboard Setup
  • Dashboard Objects Layouts

Oracle Server Management

  • Cache Management
  • Catalog Management
  • Delivers Configuration and Interface
  • Scheduler Server
  • Server Shutdown / Startup Overview
  • Log file troubleshooting and reviews
  • Managing the Oracle BI Presentation Catalog
  • Customizing the Oracle Business Intelligence User Interface
  • Custom Login screen
  • Style sheets for views and portal
  • Inspecting the query log
  • Usage logging
  • Performance Tuning Concepts