This Oracle BI 12c: Build Repositories training is designed for OBI implementation team members who want to define and build dimensional models for business intelligence processing. Learn how to build the Oracle Business Intelligence repository and perform the administrative tasks.
This Oracle BI 12c training tells you how to build and verify the 3 layers of the Oracle Business Intelligence (BI) repository. Expert Oracle University instructors will start by showing you how to use the Oracle BI Administration Tool to construct a simple repository.
- Construct a repository.
- Import the schemas.
- Design and build logical business models.
- Expose business models to the users in the OBI user interface.
- Build the physical and logical joins, simple measures, and the calculation measures.
- Validate the work by creating and running analyses.
- Verify query results using a query log.
- Implement Oracle Business Intelligence Server security.
- Manage the Oracle Business Intelligence Server cache.
- Set up a multi-user development environment.
Module 1: Repository Basics
- Lesson 1: Loading a repository into Oracle BI Server
- Lesson 2: Exploring a repository’s structure, features, and functions
- Lesson 3: Exploring Oracle BI architecture components
- Lesson 4: Using the Oracle BI Administration Tool
- Lesson 5: Creating a repository
- 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 2: Creating share measures
- Lesson 1: Creating dimension-specific aggregation rules
- Lesson 3: Creating logical dimension hierarchies
- Lesson 4: Creating level-based measures
- Lesson 5: Creating ragged and skipped-level hierarchies
- Lesson 6: Creating parent-child hierarchies
- Lesson 7: Creating presentation 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; Incorporating horizintal federation into a business model
- Lesson 2: Importing a multidimensional data source into a repository
- Lesson 3: Displaying data from multidimensional sources in Oracle BI analyses and dashboards
- Lesson 4: Adding Essbase measures to a relational model
- Lesson 5: Incorporating vertical federation into a business model
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