Oracle BI 12c: Build Repositories

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