This Oracle BI 11g R1: Build Repositories training program is based on OBI EE release Expert instructors will teach professionals step-by-step procedures for building and verifying the three layers of an Oracle BI repository; professionals will start by using the Oracle BI Administration Tool to construct a simple repository to address the fictitious company’s business needs.

Radiant Teachlearning offers Oracle BI 11g R1: Build Repositories Training Program in Classroom and Virtual instructor Led/Online mode.


Duration: 5 days


Learning Objectives

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


Benefits to You

By taking this training program, professionals will walk away with the ability to transform your organization’s data into intelligence, which will optimize your day-to-day decision making. This new understanding will help professionals provide time-critical, relevant and accurate insights. Furthermore, professionals will learn skills that will help professionals become more efficient at building repositories.


Build Logical Business Models

This training program will also teach professionals way to import design, schemas and build logical business models and expose business models to users in the Oracle BI user interface. While constructing the repository, professionals will learn way to build logical and physical joins, simple measures and calculation measures.


Model Logical Dimension Hierarchies

Professionals will then extend the initial repository and learn way to model more complex business needs. This includes logical dimension hierarchies, multiple logical, aggregate tables, table sources, partitions and time series data.


Implement Oracle BI Server Security

Oracle University instructors will also walk professionals through executing the Oracle BI Server security and managing and maintaining the Oracle BI Server cache. Professionals will learn way to set up a multi-user development environment and use Administration Tool wizards and utilities to enhance, manage and maintain repositories.


Advanced Course Topics

Finally, investing in this training program will give professionals a chance to explore more advanced topics, such as implicit fact columns, usage tracking, bridge tables, multilingual environments, write back as well as patch merge. An appendix is included, which covers architecture and the advantages of the Oracle Exalytics BI Machine.


Required Prerequisite

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

Audience Profile

  • Administrator
  • Analyst
  • Architect
  • Developer
  • Implementer

Course Content

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



Q: What knowledge should I have as a prerequisite?


A: One should be have :-

  • Knowledge about SQL design
  • Knowledge about Data Warehouse
  • Knowledge about Dimensional Modelling


Q: What does OBIEE stands for?


A: OBIEE stands for Oracle Business Intelligence Enterprise Edition.


Q: What are the three layers of BI repository?


A: The three layers are:-

  • Physical layer
  • Business model and mapping layer
  • Presentation layer


Q: What is meant by RPD file in BI?


A: The OBIEE repository database is known as RPD file defined because of OBIEE file extension. It contains metadata, security files and database connection information.


Q: What is the role of OBI administration tool?


A: The Oracle BI Administration Tool is the user interface into the layers in the repository discussed before.


Q: What’s the role of OBI reporting tool?


A: OBI tool produces and delivers the enterprise reports, scorecards, dashboards, ad hoc analysis.


Q: Why one should prefer Radiant Techlearning ?


A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.


Q: What if I/we have doubts after attending your training program?


A: Radiant team of experts would be available on the e-mail to answer your technical queries even after the training program.


Q: Does this training program include any project?


A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.


Q: If I face technical difficulty during the session then is there any remedy for that?


A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.


Q: What is schedule of training program?


A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Categories: ,

Unble To Find a Batch..?

Request a Batch