Instructor-led training
Oracle Bi 11g R1: Build Repositories Training in Honolulu, Hawaii
This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7.
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.
- Denver
- Atlanta
- Phoenix
- Boston
- Sacramento
- Austin
- Salt Lake City
- Raleigh
- Columbus
- Nashville
- Indianapolis
- Richmond
- and more
View all Oracle Bi 11g R1: Build Repositories training locations
- Denver, Colorado
- Montgomery, Alabama
- Little Rock, Arkansas
- Atlanta, Georgia
- Juneau, Alaska
- Indianapolis, Indiana
- Honolulu, Hawaii
- Trenton, New Jersey
- Springfield, Illinois
- Providence, Rhode Island
- Boston, Massachusetts
- Phoenix, Arizona
- Sacramento, California
- Dover, Delaware
- Tallahassee, Florida
- Boise, Idaho
- Richmond, Virginia
- Des Moines, Iowa
- Topeka, Kansas
- Frankfort, Kentucky
- Baton Rouge, Louisiana
- Augusta, Maine
- Annapolis, Maryland
- Lansing, Michigan
- Saint Paul, Minnesota
- Jackson, Mississippi
- Jefferson City, Missouri
- Helena, Montana
- Lincoln, Nebraska
- Carson City, Nevada
- Concord, New Hampshire
- Santa Fe, New Mexico
- Albany, New York
- Raleigh, North Carolina
- Bismarck, North Dakota
- Columbus, Ohio
- Oklahoma City, Oklahoma
- Salem, Oregon
- Harrisburg, Pennsylvania
- Columbia, South Carolina
- Pierre, South Dakota
- Nashville, Tennessee
- Austin, Texas
- Salt Lake City, Utah
- Montpelier, Vermont
- Olympia, Washington
- Charleston, West Virginia
- Madison, Wisconsin
- Cheyenne, Wyoming
- Hartford, Connecticut
- Toronto, Canada
- Berlin, Germany
- Stockholm, Sweden
- London, United Kingdom
- Dublin, Ireland
Train your team with HSG
Private, instructor-led training customized for your organization.
- Onsite or live online delivery
- Customized curriculum
- Training for groups of 3 or more
- Flexible scheduling
- Experienced instructors
Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com
Related training
Browse all Oracle courses →
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.