• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

Oracle BI 12c - Build Repositories

30 Hours
Online Instructor-led Training
USD 2800
Oracle BI 12c - Build Repositories course and certification
17 Learners

About this Course

Oracle business intelligence Repositories online course refers to step-by-step guidelines to build and verify layers of business intelligence repository. Oracle business intelligence repository online course intention is to get used to a platform that enables to create a repository and highlight the business models to end users in the Oracle business intelligence user interface.

The course on Oracle BI 12c: Build Repositories helps you understand how to build and verify the three layers of an Oracle Business Intelligence (BI) 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


Course Objective

The Oracle business intelligence Repository training is intended for the individuals who seek to implement their knowledge, skills and expand their career as Data Repository Specialist. The dedicated mentors make sure the learners to cover all topics under Oracle business intelligence Repository curriculum which will be useful for their career growth. Uplatz offers Oracle business intelligence Repository training to become a skilled Data Repository specialist.


Course Description

Oracle business intelligence Repository course program will let the participants gain complete proficiency in creating repositories and represent the business requirements in order to develop the user experience.

The Oracle business intelligence Repositories online course is ideally developed for business intelligence implementation team who can define and construct dimension models for business intelligence processing. 

In the Oracle business intelligence Repository course, Uplatz provides an in-depth training for the participants or learners to make them understand the experience of using administration tool wizards and other facilities to manage, maintain and improve repositories. 

The Oracle business intelligence Repository technology is useful in modelling complex business requirements which comprises: logical dimension hierarchy, logical table sources, and time series data. 

With the help of Oracle business intelligence Repository online course, the learners can:

  • Build repository.

  • Import schemas.

  • Design and construct logical business models.

  • Assess your work by running analyses.

  • Make use of graphs and views in analyses.

  • Validate query results using query log.

Uplatz provides an in-depth training to the learners to accelerate their knowledge and skill set required for Data Repository specialist job.


Target Audience

The Oracle business intelligence Repository course is intended for the below mentioned target audience, still if you are a newbie and want to make a career as Data Repository specialist, then the Oracle business intelligence Repository course is the best option you can choose.

  • Application Developers

  • Business Analyst

  • Technical Consultants

  • Reports Developer


Oracle BI 12c - Build Repositories

Course Details & Curriculum

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

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

  • Incorporating horizintal 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


  • 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
Career Path

The Oracle certified Data Repository specialist certification course with the help of expert professionals training is recognized across the globe. Because of the increased adoption of the Oracle Business Intelligence Administration software in various companies the participants are able to find the job opportunity easily. The leading companies hire Data Repository specialist to handle layers of business intelligence systems repository.  The Data Repository specialist can pursue a wide range of career paths.

The following are the job titles:

  • Data Repository Specialist

  • Data Entry Specialist

  • Database Administrator




Job Prospects

The Data Repository specialist draws an average salary of $48,059 per year depending on the knowledge and hands-on experience. The Business Intelligence specialist job roles are in high demand and make a rewarding career.


Interview Questions

  1. Define Business Intelligence?

The Business Intelligence’ (BI) is used for reporting the specified data of any business which is very critical and used by top management of any organization to make wise decision for the growth of their business. 

  1. Mention the vital decisions made by an organization using business intelligence?

The below decisions are decided from Business Intelligence tool:

  • determine whether a business is running as per plan.

  • analyse which things are actually going wrong.

  • Monitor corrective actions.

  • Identify the current trends of their business.

3.Mention the different stages of Business Intelligence?

The five stages of Business Intelligence:

Data Source: deals with data extraction from multiple data source.

  • Data Analysis: It is used to provide proper analysis report based on useful knowledge from a data collection.

  • Decision-Making: It makes use of the information in the proper way to provide proper graph on important events such as market changes, and poor staff performance.

  • Situation Awareness: It is about ignoring irrelevant information and retain the remaining information in the context of the business.

  • Risk Management: It is used to discover the corrective actions to be taken, or decisions made, at different scenarios.

  1. List out the benefits of Business intelligence?

 The different benefits of Business Intelligence:


  • Improvised decisions making.

  • Optimize internal business process.

  • Increase operational efficiency.

  • drive oppurtunities for new revenues.

  • Growing in terms of competitive markets.

4. Mention the various Business Intelligence tools available in the market?

  • Oracle Business Intelligence Enterprise Edition (OBIEE)

  • Cognos

  • Microstrategy

  • SAS Business Intelligence

  • Business Object

  • Tableu

  • Microsoft Business Intelligence Tool

  • Oracle Hyperion System

5. Define universe in Business Analytics?

The universe is type of semantic layer existing between database and user interface. it is one of the interfacing layers present in between the client (business user) and data warehouse. It is used to define a relationship between various tables in a data warehouse.

6. Define dashboard in a data warehouse?

The dashboard is nothing but the order arrangement of all the reports and graphs in a page. It is the collection of reports available in different format.

7. Define Fact table?

A Fact table is the center table present in star schema of a data warehouse. It is used to hold quantitative information for analysis.

8. Define Dimension table?

A dimension table is one of the key tables in a star schema of a data warehouse, which saves attribute, or dimension, that describe the objects in a fact table.

9. Define a RAGGED hierarchy?

Ragged hierarchy is used to maintain a relationship in case of parent member of at least one member of the dimension is not in the level immediately above the member.

10. Define universe in Business Analytics?

Universe is an interfacing layer between client and data warehouse. Universe specifies the relationship between various tables in data warehouse. It holds different names in different tools. It is called as repository or RPD in OBIEE.

11.Mention the different types of Data warehouse Systems?

  • Data Mart

  • Online Analytical Processing (OLAP)

  • Online Transactional Processing

  • Predictive Analysis


Will this course help me clear the certification exam? +
Which is better - Self-paced training or Instructor-led training? +
Who are the trainers? +
What if I miss a class? +
How will I execute the practical? +
Is the course material accessible after completion of the course? +
Is there any offer/discount that I can avail? +
Will I get a refund if I cancel my enrollment? +
What if I have queries after completion of the course? +

Didn't find what you are looking for?  Contact Us