• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 678-701-4914

About Course:


This training program is designed to prepare the students for OBIEE11g Data Modeling, BI Publisher, Reporting and Dashboard Building. This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious companys business requirements. This course also provides step-by-step instructions for creating Oracle BI analyses and dashboards, which compose business intelligence applications.

Duration : 30 hours

Fee: 438

Job Trends

Training Calender

Date Time Type Attend
23rd April 2024 8:00 AM   IST Regular
20th April 2024 8:00 AM   IST Demo
Contact Us

+91 769-409-5404

  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Module of Training


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary


OBIEE 12c Download  

OBIEE 12c Repository Reporting Dashboard BI Publisher Reports Training

OBIEE 12c Repository Reporting Dashboard BI Publisher Reports


Repository Building

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


* 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

Creating Answer Request


Introduction to Oracle Business Intelligence Enterprise Edition

* Introduction to Oracle BI EE
* Oracle BI 12c Architecture
* Oracle BI 12c Highlights




Working with Oracle Business Intelligence Analyses

* Introduction to Oracle BI Analysis Editor
* Oracle BI column types
* Working with analyses in Oracle BI
* Adding basic formatting
* Setting analysis properties
* Using advanced formatting





Filtering Data for Analyses

* Introduction to filters and selections
* Creating, editing, and grouping filters
* Adding prompts to analyses
* Dynamic filtering
* Using saved analyses as filters





Selecting and Grouping Data for Analysis

* Creating selection steps
* Creating groups
* Creating calculated items
* Creating direct database analysis requests
* Including advanced SQL clauses in your analysis





Advance Visualization in Analysis

* Introduction to views, graphs, and editors
* Working with views in Compound Layouts
* Creating and editing graphs
* Performing common view tasks





Showing Results with Pivot Tables

* Creating, arranging, and formatting a pivot table
* Using hierarchical columns
* Sorting in pivot tables
* Setting aggregation and using totals
* Showing an item's relative value
* Building calculations and displaying running sums





Working with Additional Views in Analyses

* Creating simple and advanced trellis views
* Creating performance tile views
* Working other view types like Treemap and Heat Matrix
* Linking master-detail views





Visualizing Data on Maps

* Oracle spatial components
* Managing map data
* Creating and editing Map views
* Interacting with map views
* Other applications and points of integration for map views





Creating Oracle Business Intelligence Dashboards

* Creating and editing dashboards
* Using the Dashboard Builder
* Exploring dashboard object properties and options
* Publishing dashboard pages
* Creating personal customizations and using other page options





Configuring Oracle Business Intelligence Dashboards

* Exploring types of dashboard content
* Embedding content in dashboards





Creating Dashboard Prompts and Variables

* Understanding variables
* Adding a named dashboard prompt to a dashboard
* Adding a hidden named dashboard prompt to a dashboard
* Creating additional prompt page and setting page preferences
* Adding variable prompts to a dashboard





Scorecards and Key Performance Indicators

* Objects and components of Oracle Scorecard and Strategy Management
* Key Performance Indicator (KPI) overview
* Scorecard document types
* Creating scorecards and KPIs
* Creating scorecard documents
* Editing scorecards and KPIs





Visual Analyzer, BI Ask, and Data Mashup

* Creating Visual Analyzer Projects
* Adding and rearranging the Visualizations
* BI Ask
* Data Mashups





Working with BI Content in Smart View

* Working with Views in Smart View Clients
* Customizing BI data in MS Office
* Copying and pasting views between Smart View clients
* Inserting BI views in to Smart View clients
* Creating and publishing views using the View Designer
* Federating data from multiple data sources





Oracle Business Intelligence Mobile

* Downloading and using the Oracle BI mobile application
* Navigating the Oracle BI mobile application
* Working with favorites and local content
* Working with BI content
* Oracle BI Mobile Security Toolkit





Administering the Presentation Catalog

* Oracle BI and catalog security overview
* Managing security using roles
* Understanding security inheritance
* Setting object permissions
* Setting system privileges
* Archiving catalog items
* Working with Oracle BI Briefing Books





Direct Database Analysis

* Direct Database Analysis Overview
* Changing Direct Database Analysis Privileges
* Creating and Executing a Direct Database Analysis





Working with Oracle BI Publisher [XML Publisher]




Introduction to BI Publisher

o Oracle BI Publisher: Business Document Requirements
o Functions of Reporting Systems
o Oracle BI Publisher Paradigm
o End-to-End View and Salient Features of BI Publisher




Getting Started with BI Publisher: Creating a Simple Report

o Opening and viewing a Predefined Report
o Creating a BI Publisher Report Based on Oracle Database
o Editing the Properties of a Report





Oracle BI Publisher: Technology and Architecture

o Describe the components of Oracle BI Publisher
o Describe the architecture of Oracle BI Publisher
o Describe the Oracle BI Publisher Underlying Technology



Who should Learn OBIEE 12c?

Prerequisite to learn OBIEE 12c

Delivery Methodology used to deliver the OBIEE 12c

Class delivery


Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's


Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?