Recognizing that time is very limited and valuable for most IT professionals, Arisant has combined its two OBIEE training courses (Building Repositories & Building Reports and Dashboards) into one, five-day instructor-led course. Arisant’s expert instructors have developed a cutting-edge curriculum and hands-on labs to allow you to master all aspects of OBIEE (administration, repository development and management, reports and dashboards development) and help you jump start your OBIEE initiatives right after the completion of this course.

As an added bonus, students attending this class, will get 40 hours of remote OBIEE support.

Dimensional Modeling in OBIEE

  • Conformed Dimensions
  • Data Source Schema to OBIEE Model Mapping
  • Star,Snowflake and Normalized Schema Mapping
  • Fully Denormalized Schema Mapping
  • Modeling Slowly Changing Dimensions

OBI Server and OBI Repository Architecture

  • Data Sources
  • OBI Server
  • OBI Presentation Services
  • OBI Repository
  • OBI Repository Metadata Layers
  • Physical Layer
  • Business Model and Mapping (BMM) Layer
  • Presentation Layer
  • OBI Administration Tool
  • Physical and Business Model Diagrams
  • Repository variables
  • Cache Management

Physical Layer

  • Creating a Repository and Importing Metadata
  • Defining Data Sources
  • Selecting Metadata Types
  • Importing Metadata
  • Physical Layer Objects
  • Creating Connection Pools
  • Schemas and Catalogs
  • Physical Display Folders
  • Physical Tables
  • Opaque Views
  • Physical Columns
  • Physical Table Aliases
  • Creating Aliases
  • Defining Physical Table Primary Keys,Foreign Keys and Joins
  • Fragmented Data

Business Model and Mapping Layer

  • Managing Logical Table Objects
  • Logical Table Source Table and Column Mappings
  • Logical Primary Key Object
  • Logical Joins
  • Managing Logical Joins
  • Logical Joins in the Business Model Diagram
  • Measure Columns
  • Rename Wizard
  • Defining Measures

Presentation Layer

  • Presentation Tables and Columns
  • Delete Unwanted Tables and Columns
  • Rename Tables and Columns
  • Object Properties

Repository Consistency Check and Deployment

  • Consistency Check Manager
  • Making a Model Available for Queries
  • Deploying Repository to OBI Server
  • Restarting OBI Server Components
  • Debugging
  • Enabling Query Logging
  • Viewing Query Logs

Working With Logical Table Sources

  • Mapping Normalized Physical Dimension Tables
  • Normalized Physical Dimension and Table Mappings
  • Normalized Physical Dimension Solution Steps
  • Defining and Verifying Physical Keys and Joins
  • Mapping Physical Table to Logical Table
  • Mapping Physical Dimension Tables
  • Mapping Physical Dimension Columns
  • Automatically Map Physical Dimension Column
  • Add Logical Columns to Presentation Layer
  • Combining Fact Data from Multiple Tables

Calculation Measures

  • Calculation Measures
  • Create Calculated Item
  • Create Logical Column
  • Map Logical Column
  • Building Expressions and Aggregation Rule
  • Create Derived Column
  • Calculation Wizard

Logical Dimensions and Hierarchies

  • Logical Dimension Types
  • Unbalanced (Ragged) Hierarchies
  • Skip Level Hierarchies
  • Hierarchies and Measures Interaction
  • Create and Use Level-Based Logical Dimension
  • Define Level Keys
  • Set Preferred Drill Paths
  • Preferred Drill Paths Interaction in Presentation Services
  • Create Level Based Measures
  • Create Share Measures
  • Create Sibling Levels
  • Add Shared Levels
  • Create and Manage Presentation Hierarchies
  • Parent/Child (Value based) Hierarchies
  • Business Model and Query Grains
  • Measure and Storage Grains

Logical Time Dimensions And Time Series Functions

  • Calendar Tables as Time Dimensions
  • Logical Time Dimensions
  • Create Logical Time Dimension
  • Time Series Functions
  • Create Time Series Measures

Working with Pre-Aggregated Facts and Dimensions

  • Modeling Aggregate Tables
  • Aggregate Physical Design and Navigation
  • Aggregates Physical Design: Aggregate Fact and Dimension Sources

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 Prompt


to get

Contact the Arisant Team | 877.556.5991 |