| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| Apr 10, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
| Jun 5, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
| Aug 14, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
| Oct 2, 2023 | 11:00 | 07:00 | EDT | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
| Dec 4, 2023 | 09:00 | 05:00 | EST | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
Oracle BI 12c: Build Repositories
This Oracle BI 12c: Build Repositories training teaches you how to build and verify the three layers of an Oracle Business Intelligence (BI) repository, step-by-step. Learn how to use the Oracle BI Administration Tool to construct a simple repository.
Duration: 5 Days
Audience
- Application Developers
- Business Analysts
- Business Intelligence Developers
- Data Modelers
- Data Warehouse Administrators
- Data Warehouse Developers
- Reports Developers
- Technical Consultants
Learning Objectives
- Model partitions and fragments to improve application performance and usability
- Use variables to streamline administrative tasks and modify metadata content dynamically
- Use time series functions to support historical time comparison analyses
- Set up security to authenticate users and assign appropriate permissions and privileges
- Apply cache management techniques to maintain and enhance query performance
- Set up query logging for testing and debugging
- Set up a multiuser development environment
- Use the Administration Tool wizards and utilities to manage, maintain, and enhance repositories
- Enable usage tracking to track queries and database usage, and improve query performance
- Perform a patch merge in a development-to-production scenario
- Use Business Application Archive (BAR) files to move Oracle BI between environments
- Build the Physical, Business Model and Mapping, and Presentation layers of a repository
- Build and run analyses to test and validate a repository
- Build simple and calculated measures for a fact table
- Create logical dimension hierarchies and level-based measures
- Check the model and then model aggregate tables to speed query processing
Topics
- Repository Basics
- Building the Physical Layer of a Repository
- Building the Business Model and Mapping Layer of a Repository
- Building the Presentation Layer of a Repository
- Testing and Validating a Repository
- Managing Logical Table Sources
- Adding Calculations to a Fact
- Working with Logical Dimensions
- Enabling Usage Tracking
- Using Model Checker and Aggregates
- Using Partitions and Fragments
- Using Repository Variables
- Modeling Time Series Data
- Modeling Many-to-Many Relationships
- Setting an Implicit Fact Column
- Importing Metadata from Multidimensional Data Sources
- Security
- Cache Management
- Managing Metadata and Working with Service Instances
- Using Administration Tool Utilities
- Multiuser Development
- Performing a Patch Merge
