During this four-day instructor-led course you will learn how to design, create and deploy all three layers of the Oracle BI repository. Expert instructors will teach you how to use the Oracle BI Administration Tool to administer and manage the repository and you will build a dimensional model and related analyses to verify your work. You will also browse related query logs to verify queries generated by OBIEE.

Course Topics

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

Course Objectives

  • Gain a solid understanding of dimensional modeling
  • Understand the OBIEE and repository architecture
  • Build and deploy the three layers of a repository
  • Learn how to use the Expression Builder and Calculation Wizard
  • Create simple and calculated measures for fact tables
  • Understand logical dimension hierarchies and level-based measures
  • Implement aggregate tables to address query performance
  • Create repository variables
  • Implement caching to improve query performance
  • Use the various Administration Tool utilities to manage and maintain the repository
  • Set up security to authenticate users and assign appropriate permissions and privileges

to get

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