Oracle BI 12c: Build Repositories

Overview

Expert Oracle University instructors will begin by teaching you how to use the Oracle BI Administration Tool to construct a simple repository.

Learn To:

• Construct the repository.
• Import schemas.
• Design and build logical business models.
• Expose business models to users in the Oracle BI user interface.
• Build physical and logical joins, simple measures, and calculation measures.
• Validate your work by creating and running analyses.
• Verify query results using the query log.
• Implement Oracle BI Server security.
• Manage the Oracle BI Server cache.
• Set up a multi-user development environment.

Audience

• Administrator
• Analyst
• Architect
• Developer
• Implementer

Suggested Prerequisites

Oracle BI 12c: Create Analyses and Dashboards

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
• CacheManagement
• Managing Metadata and Working with Service Instances
• Using Administration Tool Utilities
• MultiuserDevelopment
• Performing a Patch Merge