OBIEE Training By Amit Sharma

Topic Name BI Reporting using OBIEE

Modules  Data warehousing fundamentals

 BI Repository
 BI Answer
 BI Publisher
Duration (Hours) 40 Hours

Deliverables  Students Guides

 Lab Guides
 Video Tutorials of missing classes
 Interview Question
 Project implementation artifacts
Prerequisite Basic knowledge of Database and Data Warehousing

Fees USD 300

Contact Info aloo_a2@yahoo.com [201 203 8988]

Contact Point : aloo_a2@yahoo.com

Learnhyperion.wordpress.com
Amitsharmair.wordpress.com
Bispsolutions.wordpress.com

Learn OBIEE/Hyperion by Amit Sharma aloo_a2@yahoo.com learnhyperion.wordpress.com

 Repository Building

• Creating new calculation measures based on

Repository Basics existing logical columns
• Creating new calculation measures based on
physical columns
• Oracle BI architecture components • Creating new calculation measures using the
• Repository structure, features, and functions Calculation Wizard
• Using the OracleBI Administration Tool
• Creating a repository Creating Dimension Hierarchies and Level-Based
• Loading a repository into Oracle BI Server Measures
memory
• Creating dimension hierarchies
Building the Physical Layer of a Repository • Creating level-based measures
• Creating share measures
• Importing data sources • Creating rank measures
• Setting up connection pool properties
• Defining keys and joins Using Aggregates
• Examining physical layer object properties
• Creating alias and select tables • Purpose of aggregate tables in dimensional
modeling
Building the Business Model and Mapping Layer of a • Modeling aggregate tables to improve query
Repository performance
• Testing aggregate navigation
• Building a business model • Using the Aggregate Persistence Wizard
• Building logical tables, columns, and sources
• Defining logical joins Using Partitions and Fragments
• Building measures
• Examining business model object properties • Purpose for segmenting data into partitions and
fragments
Building the Presentation Layer of a Repository • Partition types
• Modeling partitions in an Oracle BI repository
• Exploring Presentation layer objects
• Creating Presentation layer objects Using Repository Variables
• Modifying Presentation layer objects
• Examining Presentation layer object properties • Session variables
• Repository variables
Testing and Validating a Repository • Initialization blocks
• Using the Variable Manager
• Checking repository consistency • Using dynamic repository variables as filters
• Turning on logging
• Defining a repository in the initialization file Modeling Time Series Data
• Testing a repository using Oracle BI Answers
• Inspecting the query log • Using time comparisons in business analysis
• Using Oracle BI time series functions to model
Adding Multiple Logical Table Sources time series data

• Adding multiple logical table sources to a Modeling Many-to-Many Relationships

logical table
• Specifying logical content • Using bridge tables to resolve many-to-many
relationships between dimension tables and fact
Adding Calculations to a Fact Table tables

Learn OBIEE/Hyperion by Amit Sharma aloo_a2@yahoo.com learnhyperion.wordpress.com

 • Using helper tables to model many-to-many
relationships for team-based hierarchies in a
dimension

Creating Repositories Using Multidimensional Data

Sources

• Adding a multidimensional data source an

Oracle BI repository
• Displaying data from multidimensional sources
in Oracle BI Answers requests and Oracle BI
Interactive Dashboards

Security

• Creating users and groups

• Setting permissions for users and groups
• Authenticating using a external database
• Authenticating using database authentication
• Setting query limits and timing restrictions
• Setting filters to personalize information

Cache Management

• Restricting tables as non-cacheable

• Using Cache Manager
• Inspecting cache reports
• Purging cache entries
• Modifying cache parameters and options
• Seeding the cache

Setting Up and Administering Usage Tracking

• Tracking and storing Oracle BI Server usage at

the detailed query level
• Using usage tracking statistics to optimize
query performance and aggregation strategies
• Analyzing usage results using Oracle BI
Answers and other reporting tools

Using Administration Tool wizards and utilities to

manage, maintain, and enhance
repositories

• Employing techniques to optimize Oracle BI

query performance
• Applying Oracle BI repository design principles

Learn OBIEE/Hyperion by Amit Sharma aloo_a2@yahoo.com learnhyperion.wordpress.com

 Creating Answer Request
• Embedding content in Interactive Dashboards
Working with Oracle Business Intelligence Answers • Using bookmark links to distribute and save
Interactive Dashboards
• Introduction to Oracle BI Answers
Customizing the Oracle Business Intelligence User
• Working with requests in Oracle BI Answers Interface
• Using advanced formatting
• Modifying cascading style sheets
Filtering Requests in Oracle Business Intelligence • Modifying XML message files
Answers • Making configuration changes using the
instanceconfig file
• Introduction to filters in Answers
• Adding filter prompts to requests Configuring Guided Navigation Links
• Using saved requests as filters
• Building guided navigation with static links
Oracle Business Intelligence Answers: Advanced • Building guided navigation with conditional
Features links and sections

• Combining request criteria using set operations Administering the Oracle Business Intelligence
Presentation Catalog
• Executing direct database requests
• Editing logical SQL generated by a request
• Maintaining the Oracle BI Presentation Catalog
Building Views and Charts in Requests • Managing security
• Understanding security inheritance
• Describing the Presentation Catalog structure
• Introduction to Answers views and charts
• Permission types
• Creating and editing charts
• Setting permissions using the Manage Catalog
• Performing common view tasks screen

Showing Results with Gauge Views Using Oracle Business Intelligence Delivers

• Introduction to Gauge views • Introduction to Oracle BI Delivers

• Working with Gauge views • Configuring delivery devices
• Adding delivery profiles
Showing Results with Pivot Tables • Building alerts
• Introduction to Oracle BI Scheduler
• Introduction to pivot tables • Scripted jobs
• Formatting pivot tables
• Setting aggregation rules and building formulas Using Oracle Business Intelligence Briefing Books

Creating Oracle Business Intelligence Interactive • Introduction to Oracle BI Briefing Books

Dashboards • Creating an Oracle BI Briefing Book
• Adding Content to Briefing Books
• Introduction to Interactive Dashboards and • Editing a Briefing Book
pages • Downloading and viewing a Briefing Book
• Dashboard Editor UI elements • Adding a list of Briefing Books to a Dashboard
• Composing dashboard elements • Using Briefing Books with Oracle BI Delivers

Configuring Oracle Business Intelligence Interactive Using Oracle BI for Microsoft Office
Dashboards
• Introduction to Oracle BI for Microsoft Office
• Types of dashboard content

Learn OBIEE/Hyperion by Amit Sharma aloo_a2@yahoo.com learnhyperion.wordpress.com

 • Working with Oracle BI content in Microsoft
Office applications

Using Oracle Business Intelligence Publisher

• Introduction to Oracle BI Publisher

• Creating a BI Publisher report from an Answers
request
• Creating a BI Publisher report from the BI
Server
• Integrating Discoverer worksheet content in a
BI Publisher report

Reviewing Interactive Dashboard Design Principles

and Best Practices

• Understanding dashboard design principles

• Conceptualizing dashboards
• Dashboard fundamentals

Learn OBIEE/Hyperion by Amit Sharma aloo_a2@yahoo.com learnhyperion.wordpress.com

 Working with Oracle BI Publisher [XML Publisher]

Introduction to BI Publisher

• Oracle BI Publisher: Business Document

Requirements
• Functions of Reporting Systems
• Oracle BI Publisher Paradigm
• End-to-End View and Salient Features of BI
Publisher

Oracle BI Publisher: Technology and Architecture

• Describe the components of Oracle BI

Publisher
• Describe the architecture of Oracle BI Publisher
• Describe the Oracle BI Publisher Underlying
Technology

Introduction to XML Standards

• Describe the X Standards

• Understand XML, XML Schema, DTDs, and
XSL

Getting Started with BI Publisher: Creating a Simple

Report

• Opening and viewing a Predefined Report

• Creating a BI Publisher Report Based on Oracle
Database
• Editing the Properties of a Report

Creating Simple RTF Templates

• Explain the capabilities of RTF templates

• Describe the methods for RTF template creation
• Create an RTF template

Learn OBIEE/Hyperion by Amit Sharma aloo_a2@yahoo.com learnhyperion.wordpress.com