ORACLE BI FOUNDATION SUITE – BUILDING REPOSITORIES 12C

DURATION:

4 Day Course

COURSE GOALS:

The goals of the Building Repositories 12c training course are: 

• To review the main concepts or Oracle BI EE architecture. 
• To describe the techniques used 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 business requirements. 

PRE-REQUISITES:

No pre-requisites are required to enrol in this course. However, basic data modelling knowledge will help you to quickly understand the different concepts. 

LANGUAGES:

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

TOPICS COVERED:

• OBIEE Overview. 
• Repository Basics. 
• Building the Physical, Business Model & Mapping, and Presentation Layer. 
• Testing and Validating a Repository. 
• Working with Logical Table Sources. 
• Creating Dimension Hierarchies. 
• Defining Aggregation and Fragmentation. 
• Creating Variables. 
• Creating Calculations and Time Series Measures. 
• Modelling Many-to-Many Relationships. 
• Localization and Internationalization. 
• Essbase Integration. 
• Object-level and Data-level Security. 
• Managing the OBIEE Cache. 
• Tracking system Usage. 
• Multiuser Development. 
• Configuring Write Back. 
• Merging Repositories. 
• Working with Administration Tool Utilities.