Oracle BI 11g R1: Build Repositories
This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 22.214.171.124. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository; you’ll begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company’s business requirements.
- Build and execute analyses to test and verify a dimensional business model.
- Use the Oracle BI Administration 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.
Module 1: Repository Basics
- Lesson 1: Exploring Oracle BI architecture components
- Lesson 2: Exploring a repository’s structure, features, and functions
- Lesson 3: Using the Oracle BI Administration Tool
- Lesson 4: Creating a repository
- Lesson 5: Loading a repository into Oracle BI Server
- Lesson 6: Installing the BI Client software
Module 2: Building the Physical Layer of a Repository
Module 3: Building the Business Model and Mapping Layer of a Repository
Module 4: Building the Presentation Layer of a Repository
Module 5: Testing and Validating a Repository
Module 6: Managing Logical Table Sources
Module 7: Adding Calculations to a Fact
Module 8: Working with Logical Dimensions
- Lesson 1: Creating logical dimension hierarchies
- Lesson 2: Creating level-based measures
- Lesson 3: Creating share measures
- Creating dimension-specific aggregation rules
- Lesson 5: Creating presentation hierarchies
- Lesson 6: Creating parent-child hierarchies
- Lesson 7: Creating ragged and skipped-level hierarchies
Module 9: Enabling Usage Tracking
Module 10: Using Model Checker and Aggregates
Module 11: Using Partitions and Fragments
Module 12: Using Repository Variables
Module 13: Modeling Time Series Data
Module 14: Modeling Many-to-Many Relationships
Module 15: Setting an Implicit Fact Column
Module 16: Importing Metadata from Multidimensional Data Sources
- Lesson 1: Importing a multidimensional data source into a repository
- Lesson 2: Incorporating horizontal federation into a business model
- Lesson 3: Incorporating vertical federation into a business model
- Lesson 4: Adding Essbase measures to a relational model
- Lesson 5: Displaying data from multidimensional sources in Oracle BI analyses and dashboards
Module 17: Security
Module 18: Cache Management
Module 19: Managing Metadata and Working with Service Instances
Module 20: Using Administration Tool Utilities
Module 21: Multiuser Development
Module 22: Performing a Patch Merge
0.00 average based on 0 ratings