Oracle - Course Details

OraBISEE10gR3:BR Oracle BI Suite EE 10g R3: Build Repositories

Oracle Course Description:
This Oracle BI Suite EE 10g R3: Build Repositories training teaches you how to build and verify the three layers of an Oracle BI repository through step-by-step coaching. You'll begin by using the Oracle BI Server Administration Tool to construct a simple repository to address a fictitious company's business requirements.
Oracle Course Duration:
Oracle Course Target Audience:
Application Developers,Business Analysts,Business Intelligence Developer,Data Modelers,Data Warehouse Administrator,Data Warehouse Analyst,Data Warehouse Developer,Reports Developer
Oracle Course Prerequisite:
Dimensional modeling,Basic SQL,Data warehouse design,Database design
Course Content:
  • Repository Basics

    • Oracle BI architecture components
    • Repository structure, features, and functions
    • Using the OracleBI Administration Tool
    • Creating a repository
    • Loading a repository into Oracle BI Server memory

  • Building the Physical Layer of a Repository

    • Importing data sources
    • Setting up connection pool properties
    • Defining keys and joins
    • Examining physical layer object properties
    • Creating alias and select tables

  • Building the Business Model and Mapping Layer of a Repository

    • Building a business model
    • Building logical tables, columns, and sources
    • Defining logical joins
    • Building measures
    • Examining business model object properties

  • Building the Presentation Layer of a Repository

    • Exploring Presentation layer objects
    • Creating Presentation layer objects
    • Modifying Presentation layer objects
    • Examining Presentation layer object properties

  • Testing and Validating a Repository

    • Checking repository consistency
    • Turning on logging
    • Defining a repository in the initialization file
    • Testing a repository using Oracle BI Answers
    • Inspecting the query log

  • Adding Multiple Logical Table Sources

    • Adding multiple logical table sources to a logical table
    • Specifying logical content

  • Adding Calculations to a Fact Table

    • Creating new calculation measures based on existing logical columns
    • Creating new calculation measures based on physical columns
    • Creating new calculation measures using the Calculation Wizard

  • Creating Dimension Hierarchies and Level-Based Measures

    • Creating dimension hierarchies
    • Creating level-based measures
    • Creating share measures
    • Creating rank measures

  • Using Aggregates

    • Purpose of aggregate tables in dimensional modeling
    • Modeling aggregate tables to improve query performance
    • Testing aggregate navigation
    • Using the Aggregate Persistence Wizard

  • Using Partitions and Fragments

    • Purpose for segmenting data into partitions and fragments
    • Partition types
    • Modeling partitions in an Oracle BI repository

  • Using Repository Variables

    • Session variables
    • Repository variables
    • Initialization blocks
    • Using the Variable Manager
    • Using dynamic repository variables as filters

  • Modeling Time Series Data

    • Using time comparisons in business analysis
    • Using Oracle BI time series functions to model time series data

  • Modeling Many-to-Many Relationships

    • Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
    • Using helper tables to model many-to-many relationships for team-based hierarchies in a dimension

  • Configuring Oracle Business Intelligence data and metadata to support multilingual environments

  • Setting an Implicit Fact Column

    • Adding fact columns automatically to dimension-only queries
    • Ensuring the expected results for dimension-only queries
    • Selecting a predetermined fact table source
    • Specifying a default join path between dimension tables

  • Integrating Third-Party Reporting Tools with Oracle BI Server

  • Creating Repositories Using Multidimensional Data Sources

    • Adding a multidimensional data source an Oracle BI repository
    • Displaying data from multidimensional sources in Oracle BI Answers requests and Oracle BI Interactive Dashboards

  • Security

    • Creating users and groups
    • Setting permissions for users and groups
    • Authenticating using a external database
    • Authenticating using database authentication
    • Setting query limits and timing restrictions
    • Setting filters to personalize information

  • Cache Management

    • Restricting tables as non-cacheable
    • Using Cache Manager
    • Inspecting cache reports
    • Purging cache entries
    • Modifying cache parameters and options
    • Seeding the cache

  • Setting Up and Administering Usage Tracking

    • Tracking and storing Oracle BI Server usage at the detailed query level
    • Using usage tracking statistics to optimize query performance and aggregation strategies
    • Analyzing usage results using Oracle BI Answers and other reporting tools

  • Multi-user Development

    • Setting up a multi-user development environment
    • Developing a repository using multiple developers
    • Tracking development project history

  • Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories

    • Employing techniques to optimize Oracle BI query performance
    • Applying Oracle BI repository design principles