View Schedule

What you will learn:

In this course students will gain an understanding of the Oracle BI EE architecture, with focus on the OBI repository. After learning about dimensional modelling, participants will understand the effort required to build and maintain a repository and its metadata layers (Physical, Business Model, Presentation). They will learn how to create hierarchies, manage security, caching and variables using best practices. 

Course Description:

The goals of the Building Repositories training course are::

• To review the main concepts or Oracle BI EE architecture.
• To describe the techniques to build effective Oracle EE repositories such as implementing security, level based measures and dealing with multiple sources and aggregations.
• To obtain practical experience building an Oracle BI repository.

Target Audience:

• BI Consultants – build an Oracle BI repository using best practices and proven design techniques
• IT Project Managers – understand the capabilities of an Oracle BI repository and link them to the business requirements

Topics Covered:

• Architecture, UI and Repository Basics
• Building the Physical, Business Model & Mapping, and Presentation Layers
• Testing and Validating the Repository
• Dimension Modeling Hierarchies and Multiple sources
• Creating Measures
• Using Variables
• Security
• Aggregates & Partitions
• Authentication & Authorisation
• Time Series
• Modeling Flat Structures
• Modeling 3NF
• Modeling Oracle OLAP
• Modeling Essbase cubes
• Multi User Development environment
• Best practices

Pre-requisites:

No pre-requisites are required to enroll this course. However, basic data modeling knowledge will help you to quickly understand the different concepts:

Languages

Building Repositories is offered in English and Spanish (training material is only available in English).

View Schedule