Oracle BI 12c: Build Repositories Training

Live Online & Classroom Enterprise Certification Training

This Oracle BI 12c: Build Repositories training is designed for Oracle Business Intelligence implementation team members who need to define and build dimensional models for business intelligence processing. Learn how to build an Oracle Business Intelligence repository and perform administrative tasks.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is 12c: Build Repositories Certification Training about?

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.

By taking this course, you'll walk away with the ability to 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. You will have developed the experience to use Administration Tool wizards and utilities to manage, maintain, and enhance repositories. Finally, you'll be exposed to more advanced topics, like implicit fact columns, bridge tables, usage tracking, patch merge, and managing service instances.

What are the objectives of 12c: Build Repositories Certification Training ?

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

Who is 12c: Build Repositories Certification Training for?

Data Warehouse Administrator
Application Developers
Business Analysts
Technical Consultant
Data Modelers
Reports Developer
Business Intelligence Developer
Data Warehouse Developer

What are the prerequisites for 12c: Build Repositories Certification Training?

No Prerequisites Required

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

Repository Basics

Loading a repository into Oracle BI Server

Exploring a repository's structure, features, and functions

Exploring Oracle BI architecture components

Using the Oracle BI Administration Tool

Creating a repository

Installing the BI Client software

Building the Physical Layer of a Repository

Examining physical layer object properties

Importing data sources

Setting up Connection Pool properties

Creating alias tables

Printing the physical layer diagram

Defining keys and joins

Building the Business Model and Mapping Layer of a Repository

Building logical tables, columns, and sources

Building a business model

Building measures

Examining business model object properties

Defining logical joins

Printing the business model and mapping layer diagram

Building the Presentation Layer of a Repository

Exploring presentation layer objects

Nesting presentation tables

Modifying presentation layer objects

Examining presentation layer object properties

Controlling presentation layer object visibility

Creating presentation layer objects

Testing and Validating a Repository

Executing analyses to test the repository

Uploading the repository through Enterprise Manager

Inspecting the query log

Checking repository consistency

Turning on logging

Managing Logical Table Sources

Specifying logical content

Adding multiple logical table sources to a logical table

Adding Calculations to a Fact

Creating new calculation measures based on physical columns

Creating measures using functions

Creating new calculation measures using the Calculation Wizard

Creating new calculation measures based on logical columns

Working with Logical Dimensions

Creating dimension-specific aggregation rules

Creating share measures

Creating logical dimension hierarchies

Creating level-based measures

Creating ragged and skipped-level hierarchies

Creating parent-child hierarchies

Creating presentation hierarchies

Enabling Usage Tracking

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

Creating the usage tracking tables

Setting up the sample usage tracking repository

Using usage tracking statistics to optimize query performance and aggregation strategies

Using Model Checker and Aggregates

Setting the number of elements in a hierarchy

Using the Aggregate Persistence Wizard

Testing aggregate navigation

Using Model Check Manager

Modelling aggregate tables to improve query performance

Using Partitions and Fragments

Exploring partition types

Modeling partitions in an Oracle BI repository

Using Repository Variables

Creating initialization blocks

Creating session variables

Using the Variable Manager

Using dynamic repository variables as filters

Creating repository variables

Modelling Time Series Data

Using time comparisons in business analysis

Using Oracle BI time series functions to model time series data

Modelling 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

Incorporating horizontal federation into a business model

Importing a multidimensional data source into a repository

Displaying data from multidimensional sources in Oracle BI analyses and dashboards

Adding Essbase measures to a relational model

Incorporating vertical federation into a business model

Security

Setting up object permissions

Creating users and groups

Exploring Oracle BI default security settings

Setting query limits and timing restrictions

Creating application roles

Setting row-level security (data filters)

Cache Management

Seeding the cache

Inspecting cache reports

Using Cache Manager

Purging cache entries

Restricting tables as non-cacheable

Modifying cache parameters and options

Managing Metadata and Working with Service Instances

Managing service instances using WLST commands

Managing BAR files using WebLogic Scripting Tool (WLST) commands

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

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

Tracking development project history

Developing a repository using multiple developers

Performing a Patch Merge

Creating a patch

Equalizing objects

Making merge decisions

Comparing repositories

Applying a patch

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

12c: Build Repositories Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree