Oracle BI 11g R1: Build Repositories

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

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

--------------------------------------------------------

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

--------------------------------------------------------

Oracle BI 11g R1: Build Repositories

Oracle BI 11g R1: Build Repositories

Uplatz

IT Training

IT Training

General