STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online!

Oracle BI Suite 11g R1: Build Repositories

Overview

In this Oracle BI 11g R1: Build Repositories course, you will learn 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 Objective

  • 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
This course prepares you for Exam 1Z0-591-JPN. Download Course Contents
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 5 Days
Fee : Sydney : USD 3,000 London : USD 3,200 Dubai : USD 5,100 India : USD 2,600
April
06-10 (Delhi) (Venue)
13-17 (Chennai) (Venue)
13-17 (London) (Venue)
20-24 (Bangalore) (Venue)
20-24 (Birmingham) (Venue)
20-24 (Brisbane) (Venue)
20-24 (Manchester) (Venue)
20-24 (Melbourne) (Venue)
20-24 (Sydney) (Venue)
May
04-08 (Delhi) (Venue)
11-15 (Chennai) (Venue)
11-15 (London) (Venue)
18-22 (Bangalore) (Venue)
18-22 (Birmingham) (Venue)
18-22 (Brisbane) (Venue)
18-22 (Manchester) (Venue)
18-22 (Melbourne) (Venue)
18-22 (Sydney) (Venue)
June
01-05 (Delhi) (Venue)
08-12 (Chennai) (Venue)
08-12 (London) (Venue)
15-19 (Bangalore) (Venue)
15-19 (Birmingham) (Venue)
15-19 (Brisbane) (Venue)
15-19 (Manchester) (Venue)
15-19 (Melbourne) (Venue)
15-19 (Sydney) (Venue)

Enquire Now




Input symbols

  • 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
)