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.
Learn To:
- 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