Oracle BI Server Administrator 10g: Build Repositories Rel 1

start > courses and registration > training feature sheet

Oracle BI Server Administrator 10g: Build Repositories Rel 1

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

BI10g-SERVER-ADM

length.

3 days

type.

Instructor-Led

partner.

Oracle

price.

$3,000

This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository: the Physical layer, the Business Model and Mapping layer, and the Presentation layer. Begin by using the Oracle BI Server Administration Tool to construct a simple repository to address a fictitious company's business requirements. Learn to import schemas, design and build logical business models, and expose business models to users in Oracle BI Answers. In the process of constructing the repository, learn how to build physical and logical joins, simple measures, and calculation measures. Students also learn how to validate their work by building queries and verifying query results using Oracle BI Answers and the query log.

Extend the initial repository and build expertise in modeling more complex business requirements, such as dimension hierarchies, multiple logical sources, aggregate tables, partitions, and time series data. Gain skills in implementing Oracle BI Server security, managing Oracle BI Server cache, setting up a multi-user development environment, and using Administration Tool wizards and utilities to manage, maintain, and enhance repositories.

Learn To:

	Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository
	Use the Oracle BI Adminstration Tool to administer Oracle BI Server
	Build a dimensional business model to address business intelligence requirements
	Use Oracle BI Answers to build and execute queries to test and verify a dimensional business model

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

	Application Developers
	Business Intelligence Developer
	Data Warehouse Developer
	Data Warehouse Administrator
	Business Analysts
	Data Modelers
	Data Warehouse Analyst
	Portal Developer

prerequisites

Required Prerequisites:

	Oracle BI Presentation Services 10g: Create Reports/Dashboards
	Oracle BI 10g: Analytics Overview - Online Course
	Oracle BI Presentation Services 10g: Create Reports/Dashboards NEW
	Oracle BI 10g: Analytics Overview - Online Course NEW

skills gained

	Build the Physical, Business Model and Mapping, and Presentation layers of a repository
	Use Answers to run queries to test and validate a repository
	Build simple and calculated measures for a fact table
	Create dimension hierarchies and level-based measures
	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
	Apply cache management techniques to maintain and enhance query performance
	Set up query logging for testing and debugging
	Set up a multi-user development environment
	Use Administration Tool wizards and utilities to manage, maintain, and enhance repositories

suggested prerequisites:

	Dimensional modeling
	Basic SQL
	Data warehouse design
	Database design

related courses, exams and materials

	before related training and products

	Oracle BI 10g: Analytics Overview
	Oracle BI Presentation Services 10g: Create Reports/Dashboards

	after related training and products

	Analytics: Advanced Server Architect
	Analytics: Server Architect Case Study

course content details

	Lesson 1: Repository Basics

	Oracle BI architecture components
	Repository structure, features, and functions
	Using the Oracle BI Administration Tool
	Creating a repository
	Loading a repository into Oracle BI Server memory

	Lesson 2: 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 and select tables

	Lesson 3: 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

	Lesson 4: Building the Presentation Layer of a Repository

	Exploring Presentation layer objects
	Creating Presentation layer objects
	Modifying Presentation layer objects
	Examining Presentation layer object properties

	Lesson 5: Testing and Validating a Repository

	Checking repository consistency
	Turning on logging
	Defining a repository in the initialization file
	Testing a repository using Oracle BI Answers
	Inspecting the query log

	Lesson 6: Adding Multiple Logical Table Sources

	Adding multiple logical table sources to a logical table
	Specifying logical content

	Lesson 7: Adding Calculations to a Fact Table

	Creating new calculation measures based on existing logical columns
	Creating new calculation measures based on physical columns
	Creating new calculation measures using the Calculation Wizard

	Lesson 8: Creating Dimension Hierarchies and Level-Based Measures

	Creating dimension hierarchies
	Creating level-based measures
	Creating share measures
	Creating rank measures

	Lesson 9: Modeling Aggregates

	Purpose of aggregate tables in dimensional modeling
	Modeling aggregate tables to improve query performance
	Testing aggregate navigation
	Using the aggregate persistence wizard

	Lesson 10: Using Partitions and Fragments

	Purpose for segmenting data into partitions and fragments
	Partition types
	Modeling partitions in an Oracle BI repository

	Lesson 11: Repository Variables

	Session variables
	Repository variables
	Initialization blocks
	Using the Variable Manager
	Using dynamic repository variables as filters

	Lesson 12: Modeling Time Series Data

	Using time comparisons in business analysis
	Using Oracle BI time series functions to model time series data

	Lesson 13: Security

	Creating users and groups
	Setting permissions for users and groups
	Authenticating using a external database
	Authenticating using database authentication
	Setting query limits and timing restrictions
	Setting filters to personalize information

	Lesson 14: Cache Management

	Restricting tables as non-cacheable
	Using Cache Manager
	Inspecting cache reports
	Purging cache entries
	Seeding the cache
	Modifying cache parameters and options

	Lesson 15: Multi-user Development

	Setting up a multi-user development environment
	Developing a repository using multiple developers
	Tracking development project history

	Lesson 16: Using Administration Tool Utilities

Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories