Oracle - Course Details

OraVI11gR1:BR-SSC Oracle BI 11g R1: Build Repositories - Self-Study Course

Oracle Course Description:
This Oracle BI 11g R1: Build Repositories - Self-Study Course teaches you to build and verify the three layers of an Oracle BI repository, step-by-step. You'll begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements.
Oracle Course Duration:
Self Placed
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:
Basic SQL,Data warehouse design,Database design Dimensional modeling
Course Content:
  • Repository Basics

    • Exploring Oracle BI architecture components
    • Exploring a repository's structure, features, and functions
    • Using the Oracle BI 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 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
    • Executing analyses to test a repository
    • Inspecting the query log

  • Managing Logical Table Sources

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

  • Adding Calculations to a Fact

    • 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 measures using functions

  • Working with Logical Dimensions

    • Creating logical dimension hierarchies
    • Creating level-based measures
    • Creating share measures
    • Creating dimension-specific aggregation rules
    • Creating presentation hierarchies
    • Creating parent-child hierarchies
    • Using calculated members

  • Using Aggregates

    • Modeling aggregate tables to improve query performance
    • Setting the number of elements in a hierarchy
    • Testing aggregate navigation
    • Using the Aggregate Persistence Wizard

  • Using Partitions and Fragments

    • Exploring partition types
    • Modeling partitions in an Oracle BI repository
    • Using the Calculation Wizard to create derived measures

  • Using Repository Variables

    • Creating session variables
    • Creating repository variables
    • Creating 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

  • Localizing Oracle BI Metadata and Data

    • Localizing repository metadata
    • Localizing Oracle BI data

  • 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

  • Importing Metadata from Multidimensional Data Sources

    • Importing a multidimensional data source into a repository
    • Incorporating horizontal federation into a business model
    • Incorporating vertical federation into a business model
    • Adding Essbase measures to a relational model
    • Displaying data from multidimensional sources in Oracle BI analyses and dashboards

  • Security

    • Exploring Oracle BI default security settings
    • Creating users and groups
    • Creating application roles
    • Setting up object permissions
    • Setting row-level security (data filters)
    • Setting query limits and timing restrictions

  • Cache Management

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

  • Enabling Usage Tracking

    • Setting up the sample usage tracking repository
    • 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

  • Multiuser Development

    • Setting up a multiuser development environment
    • Developing a repository using multiple developers
    • Tracking development project history

  • Configuring Write Back

    • Enabling write back in a repository
    • Creating a write back template
    • Granting write back privileges
    • Enabling write back in an analysis

  • Performing a Patch Merge

    • Comparing repositories
    • Equalizing objects
    • Creating a patch
    • Applying a patch
    • Making merge decisions