0345 4506120

Oracle BI 12c Build Repositories

This practical course gives attendees essentials skills to build and harness the Oracle 12c Business Intelligence (OBI) repository.

Learning Objectives

This course, from a ground up approach will provide attendees essential RPD (Repository Metadata) management skills progressing to also extend the initial  repository and model more complex business requirements, including:  logical dimension hierarchies, multiple logical table sources, aggregate  tables, partitions, and time series data. Following training attendees will have the essential Oracle 12c Business Intelligence (OBI) repository management skillset.

The course provides attendees hands on experience to build their own 12 OBI Repository (RPD, Repository Metadata). Students learn how to build physical and  logical joins, simple measures, and calculation measures and how to validate their work by creating and running analyses,  and verifying query results using a variety of methods and tools.

This hand on course will also demonstrate how to import schemas,  design and build logical business models, and expose business models to  users in the Oracle BI user interface.

You will learn how to model more  complex business requirements, such as logical dimension hierarchies,  multiple logical table sources, aggregate tables, partitions, and time  series data.



Course Content

Repository Basics Oracle BI architecture Repository structures, features, and functions Oracle BI Administration Tool Creating a repository Loading a repository into Oracle BI Server

The Repository Physical Layer Importing data sources Connection Pool properties Defining keys and joins Physical layer object properties Alias tables Working with the physical layer diagram  

Business Model and Repository Mapping Layer Building a business model Building logical tables, columns, and sources Defining logical joins Building measures Examining business model object properties Working with the business model and mapping layer diagram

Repository Presentation Layer 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.

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include