Job Meter = High
Oracle BI 11g R1: Build Repositories
30 Hours
Online Instructor-led Training
USD 2800
About this Course
This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository; you'll begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements.
--------------------------------------------------------
Course Objectives
--------------------------------------------------------
Target Audience
--------------------------------------------------------
Course Objectives
- Build and run analyses to test and validate a repository
- Build simple and calculated measures for a fact table
- Create logical dimension hierarchies and level-based measures
- Check the model and then model aggregate tables to speed query processing
- Model partitions and fragments to improve application performance and usability
- Use variables to streamline administrative tasks and modify metadata content dynamically
- Use time series functions to support historical time comparison analyses
- Set up security to authenticate users and assign appropriate permissions and privileges
- Build the Physical, Business Model and Mapping, and Presentation layers of a repository
- Apply cache management techniques to maintain and enhance query performance
- Set up query logging for testing and debugging
- Set up a multiuser development environment
- Use the Administration Tool wizards and utilities to manage, maintain, and enhance repositories
- Enable usage tracking to track queries and database usage, and improve query performance
- Perform a patch merge in a development-to-production scenario
- Describe Exalytics machine and the Summary Advisor tool used in the machine
Target Audience
- Administrator
- Analyst
- Architect
- Developer
- Implementer
Oracle BI 11g R1: Build Repositories
Course Details & Curriculum
- Repository Basics
- Building the Physical Layer of a Repository
- Building the Business Model and Mapping Layer of a Repository
- Building the Presentation Layer of a Repository
- Testing and Validating a Repository
- Managing Logical Table Sources
- Adding Calculations to a Fact
- Working with Logical Dimensions
- Using Aggregates
- Using Partitions and Fragments
- Using Repository Variables
- Modeling Time Series Data
- Modeling Many-to-Many Relationships
- Localizing Oracle BI Metadata and Data
- Setting an Implicit Fact Column
- Importing Metadata from Multidimensional Data Sources
- Security
- Cache Management
- Enabling Usage Tracking
- Multiuser Development
- Configuring Write Back
- Performing a Patch Merge