Oracle BI 12c Build Repositories Ed 1

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 enchance 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

Topics

• BI 12c: Build Repositories Course Introduction
• 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
• Working with Logical Dimension Hierarchies
• Managing Usage Tracking
• Using Model Checker and Aggregates
• Using Partitions and Fragments