Oracle BI 11g R1: Build Repositories

Course details

This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements. Students import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface. In the process of constructing the repository, students learn how to build physical and logical joins, simple measures, and calculation measures. Students also learn how to validate their work by creating and running analyses, and verifying query results using the query log. Students then extend the initial repository and learn how to model more complex business requirements, such as logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data. Students also learn how to implement Oracle BI Server security, manage Oracle BI Server cache, set up a multiuser development environment, and use Administration Tool wizards and utilities to manage, maintain, and enhance repositories. Finally, students are exposed to more advanced topics, such as implicit fact columns, bridge tables, usage tracking, multilingual environments, write back, and patch merge.

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
• A Live Virtual Class (LVC) is exclusively for registered students; unregistered inpiduals may not view an LVC at any
• time. Registered students must view the class from the country listed in the registration form. Unauthorized recording,
• copying, or transmission of LVC content may not be made.
• 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
• 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
• Enable usage tracking to track queries and database usage, and improve query performance
• Perform a patch merge in a development-to-production scenario
• Configure Oracle BI to support multilingual environments
• Build the Physical, Business Model and Mapping, and Presentation layers of a repository

Course Topics:

• 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 memory
• 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
• 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
• Building the Presentation Layer of a Repository
• Exploring Presentation layer objects
• Creating Presentation layer objects
• Modifying Presentation layer objects
• Examining Presentation layer object properties