During this four-day instructor-led course you will learn how to create Oracle BI reports (analyses) and dashboards using the various interfaces available in OBIEE. Expert instructors will teach you how to build basic analyses, add advanced formatting, and take advantage of the powerful features that allow you to create advanced data visualizations. You will learn how to create interactive dashboards and schedule reports for delivery to end users.

Course Topics

Introduction to Oracle Business Intelligence EE

  • Oracle BI EE Architecture Overview
  • Presentation Services
  • Presentation Server and Catalog
  • BI Server and Repository
  • Data Sources
  • Oracle BI EE User Interface at a Glance

Creating and Managing Analyses

  • Analysis Editor
  • Subject Areas
  • Column Types
  • Hierarchies
  • Creating and Editing an Analysis
  • Analysis Editor Environment
  • Constructing An Analysis

Filtering and Selecting Data for Analyses

  • Filters and Selection Steps
  • Filter Combinations and Groups
  • Filtering Using Results of Other Analysis
  • Groups
  • Calculated Items
  • Analysis Prompts

Analysis Presentation Views

  • View Containers – Compound Layouts
  • Adding Views to an Analysis
  • Dashboard Preview
  • Interacting With Views
  • Drilling in Views
  • Master/Detail Views
  • Pivot Tables
  • Action Links
  • Totals and Running Sums (Cumulative Totals)
  • Aggregation Rules for Measure Columns
  • Combining Member Values into Bins
  • Graph Views
  • View Selector View
  • Gauge View

Key Performance Indicators

  • KPI Overview
  • How KPIs are viewed by end users?
  • How are KPIs used in OBIEE?
  • KPI Dimensions
  • Creating KPIs
    – General Properties
    – Dimensionality
    – States
    – Related Documents
    – Custom Attributes
  • Create KPI Watchlists
  • KPI Watchlists


  • Creating Dashboards and Dashboard Pages
  • Dashboard Builder
  • Adding Dashboard Content
  • Dashboard Columns and Sections
  • Dashboard Sections
    – Properties
    – Layout
    – Conditions
    – Formatting
    – Drill Behavior
  • Dashboard Content
    – Report Links
    – Analysis Views
    – Analysis Results
  • Dashboard Pages Create and Save Customizations
  • Sharing Dashboard Pages by URL
  • Publishing Dashboard Pages
  • Managing Dashboard Pages and Dashboard Access
  • Dashboard Prompts
  • Create Dashboard Prompt
  • Create Dashboard Column Prompts
  • Add Dashboard Prompt to Dashboard
  • Hidden Dashboard Prompts
  • Create Hidden Dashboard Prompts

Course Objectives

  • Create and modify analyses using the Analysis Editor interface
  • Add feature rich formatting to analyses
  • Build graphs and charts in analyses
  • Add hierarchical columns in analyses
  • Create, modify and administer Interactive Dashboards
  • Create and add filters to analyses and dashboards
  • Create selection steps, groups and calculated items
  • Create guided navigation links within Interactive Dashboards
  • Create and configure Agents to execute analyses and dashboard pages and schedule them for delivery to subscribers
  • Learn how to administer analyses, dashboards and Web Catalog objects
  • Create Key Performance Indicators and Scorecards
  • Use security rules to grant access to analyses and dashboards to users

to get

Contact the Arisant Team | 877.556.5991 | sales@arisant.com