OBIEE-Oracle Business Intelligence training in chennai

OBIEE Overview

New Features of OBIEE

OBIEE Architecture
• Clients
• OBIEE Presentation Services
• OBIEE Server
• OBIEE Repository (.rpd)
• Data Sources
OBIEE Components
• OBIEE Administration Tool
• OBIEE Answers
• Intelligence dashboards
Repository Basics
• Oracle Business Analysis Warehouse
• DAC and Informatica Server
• Informatica Server ETL
• Sample Request Processing
• Using the OracleBI Administration Tool
• Repository Directory
• Repository Files ( Initialization files and log files)
• Loading a repository into Oracle BI Server memory
• Creating a repository
• Connection Pool
• Repository Modes ( ONLINE and OFFLINE )
• Physical Layer
• Business Model & Mapping Layer
• Presentation Layer
• Presentation Catalogs, Folders and Columns
• Error Messages
Building the Physical Layer of a Repository
• Defining an ODBC System DSN
• Setting up connection pool properties
• Importing data sources ( Physical Schema )
• Verifying the import
• Defining physical keys and joins
• Creating alias and select tables
Building the Business Model and Mapping Layer of a Repository
• Creating the logical business model
• Creating the logical tables, columns, and sources
• Defining logical joins
• Adding Calculation to a Fact Table
• Building measures
Building the Presentation Layer of a Repository
• Creating a new Presentation Catalog
• Modifying Presentation layer objects
• Rename tables
• Reorder Table
Testing and Validating a Repository
• Checking repository consistency
• Defining a repository in the initialization file
• Testing a repository using Oracle BI Answers
Adding Multiple Logical Table Sources
• Adding multiple logical table sources to a logical table
• Specifying logical content
Adding Calculations to a Fact Table
• Creating new calculation measures based on existing logical columns
• Creating new calculation measures based on physical columns
• Creating new calculation measures using the Calculation Wizard
Creating Dimension Hierarchies and Level-Based Measures
• Creating dimension hierarchies
• Creating level-based measures
Creating & Using Aggregates
• Purpose of aggregate tables in dimensional modeling
• Modeling aggregate tables to improve query performance
• Testing aggregate navigation
Using Initialization Blocks Repository Variables
Creating Dynamic Repository Variables
Execute Direct Database Requests
• Accessing database directly
Creating Time series Measures
• Using time comparisons in business analysis
• Using Oracle BI time series functions to model time series data
Providing Security for Groups & Users




Answers (REPORTS)


Working with Oracle Business Intelligence Answers
• Introduction to Oracle BI Answers
• Working with requests in Oracle BI Answers
• Using advanced formatting
• Creating report Level Hierarchy
Filtering Requests in Oracle Business Intelligence Answers
• Introduction to filters in Answers
• Adding filter prompts to requests
• Using saved requests as filters
Building Views and Charts in Requests
• Introduction to Answers views and charts
• Creating and editing charts
• Performing common view tasks
• Creating a Narrative View
• Creating a column Selector
• Creating View Selector
Showing Results with Pivot Tables
• Introduction to pivot tables
• Formatting pivot tables
• Setting aggregation rules and building formulas



Creating Oracle Business Intelligence Interactive Dashboards
• Introduction to Interactive Dashboards and pages
• Adding Objects to Dashboard
• Creating Dashboard prompts
• Embedding content in an Interactive Dashboard


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