Instructor-led training

Oracle Bi 11g R1: Build Repositories Training in Sea Tac, Washington

This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7.

Request a Training Proposal View Course Outline

What you'll learn

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. Learn To: - Build and execute analyses to test and verify a dimensional business model. - Use the Oracle BI Adminstration Tool to administer Oracle BI Server. - Use the Oracle BI Administration Tool to build, manage and maintain an Oracle BI repository. - Build a dimensional business model to address business intelligence requirements. - Validate your work by creating and running analyses, and verifying query results using the query log.

Prerequisites

- Knowledge on Basic SQL - Knowledge on Dimensional modeling - Knowledge on Data warehouse design

Course Outline

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

- Installing the BI Client software

- Overview of Exalytics Machine

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

- Printing the physical layer diagram

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

- Printing the business model and mapping layer diagram

Building the Presentation Layer of a Repository

- Exploring presentation layer objects

- Creating presentation layer objects

- Modifying presentation layer objects

- Examining presentation layer object properties

- Nesting presentation tables

- Controlling presentation layer object visibility

Testing and Validating a Repository

- Checking repository consistency

- Turning on logging

- Uploading the repository through Enterprise Manager

- Executing analyses to test the 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 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

- Creating ragged and skipped-level hierarchies

Enabling Usage Tracking

- Creating the usage tracking tables

- 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

Using Model Checker and Aggregates

- Using Model Check Manager

- Modeling aggregate tables to improve query performance

- Using the Aggregate Persistence Wizard

- Testing aggregate navigation

- Setting the number of elements in a hierarchy

Using Partitions and Fragments

- Exploring partition types

- Modeling partitions in an Oracle BI repository

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

Setting an Implicit Fact Column

- Ensuring the correct 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 horizintal 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

Exploring the Summary Advisor Tool

- Setting up Summary Advisor

- Running the Summary Advisor wizard to create the aggregate script

- Running the aggregate script to create the aggregates

Using Administration Tool Utilities

- Using the various Administration Tool utilities

- Using BI Server XML API to create XML representation of repository metadata

Multiuser Development

- Setting up a multiuser development environment

- Developing a repository using multiple developers

- Tracking development project history

Performing a Patch Merge

- Comparing repositories

- Equalizing objects

- Creating a patch

- Applying a patch

Making merge decisions

Training locations

Oracle Bi 11g R1: Build Repositories training across the U.S. and beyond.

We provide Oracle Bi 11g R1: Build Repositories training onsite and live online for organizations throughout the United States and internationally.

View all Oracle Bi 11g R1: Build Repositories training locations

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176