Oracle BI 11g R1 - Build Repositories
This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository.
COURSE SCHEDULE
Oracle BI 11g R1 - Build Repositories
Length Days: 5
Length Hours: 40
- Application Developers
- Business Analysts
- Business Intelligence Developer
- Data Modelers
- Data Warehouse Administrator
- Data Warehouse Analyst
- Reports Developer
- Technical Consultant
Build and run analyses to test and validate a repository:
- 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
- Describe Exalytics machine and the Summary Advisor tool used in the machine
- 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
- 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
- Build the Physical, Business Model and Mapping, and Presentation layers of a repository
- Apply cache management techniques to maintain and enhance query performance
Actual course outline may vary depending on offering center. Contact your sales representative for more information.