0345 4506120

Oracle BI Enterprise Edition 11g Build Repositories

Oracle BI Enterprise Edition 11g: Build Repositories training course is designed to give students a step-by-step procedure for building and verifying the three layers of an Oracle BI repository.

We don't currently have any courses listed for Oracle BI Enterprise Edition 11g Build Repositories, would you like to view all courses for Oracle?

Learning Objectives

iTrains OBIEE 11g Build Repositories course will use the Oracle BI Administration Tool to construct a simple repository. On completion of constructing the repository, students learn how to build physical and logical joins, simple measures, and calculation measures. Students will also learn how to validate their work by creating and running analyses, and verifying query results using the query log.

This hand on course will also demonstrate how to import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface.

Using the initial repository Students will learn how to model more complex business requirements, such as logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data.

This course also covers the Implementation of Oracle BI Server security, management of Oracle BI Server cache, the set up of a multi-user development environment, and the use Administration Tools wizards and utilities used to manage, maintain, and enhance repositories. More advanced topics, such as implicit fact columns, bridge tables, usage tracking, multilingual environments, write back, and patch merge will be discussed.


Business Intelligence Knowledge
Data Warehouse Design
Basic SQL
Database Design
Dimensional Modeling

Course Content

Introduction Course Structure and Agenda

Overview of Reporting Oracle General Ledger Reports Oracle General Ledger Standard Reports Financial Statement Generator Oracle Financial Analyzer Oracle Discoverer RXi Reports Administration Tool Oracle Reports SQL Reports Report Manager Comparison of Reporting Tools


GL Reports Overview Concurrent Manager Concurrent Processing Definitions Useful Standard Reports Submit Request Flow Run a Standard General Ledger Report Scheduling Options Completion Options View Requests


Financial Statement Generator Introduction to FSG Reporting FSG Components Plan a FSG Report Use Row and Column Sets Define Row Sets Define Column Sets Generate an ad hoc FSG Report Define a FSG Report Run a FSG Report Use a Content Set


Report Manager Overview of Report Manager Report Manager structure and access Publish a report to Reports Repository View a report in Reports Repository Publish a report from eBusiness Homepage Analyse a Financial Report with Report Manager


FSG Exercises Define a Row Set Define a Column Set Define an FSG Report Run an FSG Report View Report Requests Define a Content Set Define Display Groups and Display Sets Define a Row Order


Report Manager Exercises Publish a Report from a Form Function Analyse Report Output Export Analysis to MS Excel View a Report from Repository Management

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


Our Customers Include