Instructor-led training

Oracle BI 12C: Build Repositories Training in Alpena, Michigan

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.

Request a Training Proposal View Course Outline

What you'll learn

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

Prerequisites

Before taking this course, students should have basic knowledge of SQL, database design, dimensional modeling and data warehouse design principles.

Course Outline

Repository Basics

- Exploring Oracle BI architecture components

- Exploring a repository's structure, features, and functions

- Using the Oracle BI Administration Tool

- Creating a repository

- Loading a repository into Oracle BI Server

- Installing the BI Client software

Building the Physical Layer of a Repository

- Importing data sources

- Setting up Connection Pool properties

- Defining keys and joins

- Examining physical layer object properties

- Creating alias tables

- Printing the physical layer diagram

Building the Business Model and Mapping Layer of a Repository

- Building a business model

- Building logical tables, columns, and sources

- Defining logical joins

- Building measures

- Examining business model object properties

- Printing the business model and mapping layer diagram

Building the Presentation Layer of a Repository

- Exploring presentation layer objects

- Creating presentation layer objects

- Modifying presentation layer objects

- Examining presentation layer object properties

- Nesting presentation tables

- Controlling presentation layer object visibility

Testing and Validating a Repository

- Checking repository consistency

- Turning on logging

- Uploading the repository through Enterprise Manager

- Executing analyses to test the repository

- Inspecting the query log

Managing Logical Table Sources

- Adding multiple logical table sources to a logical table

- Specifying logical content

Adding Calculations to a Fact

- Creating new calculation measures based on logical columns

- Creating new calculation measures based on physical columns

- Creating new calculation measures using the Calculation Wizard

Creating measures using functions

- Working with Logical Dimensions

- Creating logical dimension hierarchies

- Creating level-based measures

- Creating share measures

- Creating dimension-specific aggregation rules

- Creating presentation hierarchies

- Creating parent-child hierarchies

- Creating ragged and skipped-level hierarchies

Enabling Usage Tracking

- Creating the usage tracking tables

- Setting up the sample usage tracking repository

- Tracking and storing Oracle BI Server usage at the detailed query level

- Using usage tracking statistics to optimize query performance and aggregation strategies

Using Model Checker and Aggregates

- Using Model Check Manager

- Modeling aggregate tables to improve query performance

- Using the Aggregate Persistence Wizard

- Testing aggregate navigation

- Setting the number of elements in a hierarchy

Using Partitions and Fragments

- Exploring partition types

- Modeling partitions in an Oracle BI repository

- Using Repository Variables

- Creating session variables

- Creating repository variables

- Creating initialization blocks

- Using the Variable Manager

- Using dynamic repository variables as filters

Modeling Time Series Data

- Using time comparisons in business analysis

- Using Oracle BI time series functions to model time series data

Modeling Many-to-Many Relationships

- Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables

Setting an Implicit Fact Column

- Ensuring the correct results for dimension-only queries

- Selecting a predetermined fact table source

- Specifying a default join path between dimension tables

Importing Metadata from Multidimensional Data Sources

- Importing a multidimensional data source into a repository

- Incorporating horizintal federation into a business model

- Incorporating vertical federation into a business model

- Adding Essbase measures to a relational model

- Displaying data from multidimensional sources in Oracle BI analyses and dashboards

Security

- Exploring Oracle BI default security settings

- Creating users and groups

- Creating application roles

- Setting up object permissions

- Setting row-level security (data filters)

- Setting query limits and timing restrictions

Cache Management

- Restricting tables as non-cacheable

- Using Cache Manager

- Inspecting cache reports

- Purging cache entries

- Modifying cache parameters and options

- Seeding the cache

Managing Metadata and Working with Service Instances

- Using BI Application Archive (BAR) files to export and import service instances

- Managing BAR files using WebLogic Scripting Tool (WLST) commands

- Managing service instances using WLST commands

Using Administration Tool Utilities

- Using the various Administration Tool utilities

- Using BI Server XML API to create XML representation of repository metadata

Multiuser Development

- Setting up a multiuser development environment

- Developing a repository using multiple developers

- Tracking development project history

Performing a Patch Merge

- Comparing repositories

- Equalizing objects

- Creating a patch

- Applying a patch

- Making merge decisions

Training locations

Oracle BI 12C: Build Repositories training across the U.S. and beyond.

We provide Oracle BI 12C: Build Repositories training onsite and live online for organizations throughout the United States and internationally.

View all Oracle BI 12C: Build Repositories training locations

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176