OBIEE Administrator

OBIEE Administrator



    Oracle Business Intelligence Enterprise Edition(Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, real-time predictive intelligence, and an enterprise reporting engine. Oracle Business Intelligence is designed to bring greater business visibility and insight to a wide variety of users.

    OBJECTIVE of the Training:

    Oracle BI Enterprise Edition (sometimes simply referred to as Oracle Business Intelligence) provides a full range of business intelligence capabilities that allow you to:

    • Collect up-to-date data from your organization
    • Present the data in easy-to-understand formats (such as tables and graphs)
    • Deliver data in a timely fashion to the employees in your organization
    • These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.

    OBIEE Administrator Course Content:

    1.OBI Architecture

    • Clients
    • OBI Presentation Services
    • OBI Server
    • OBI Repository (.rpd)
    • Data Sources

    2.OBI Components

    • OBI Administration Tool
    • OBI Answers
    • Intelligence dashboards

    3.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)
    • Informatica Server ETLLoading 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

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

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

    6.Building The Presentation Layer Of a Repository

    • Creating a new Presentation Catalog
    • Modifying Presentation layer objects
    • Rename tables
    • Reorder Table

    7.Testing And Validating a Repository

    • Checking repository consistency
    • Defining a repository in the initialization file
    • Testing a repository using Oracle BI Answers
    • Message Severity
    • Viewing Server Logs

    8.Adding Multiple Logical Table Sources

    • Adding multiple logical table sources to a logical table
    • Specifying logical content

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

    10.Creating Dimension Hierarchies And Level-Based Measures

    • Creating dimension hierarchies
    • Creating level-based measures

    11.Creating And Using Agrregates

    • Purpose of aggregate tables in dimensional modeling
    • Modeling aggregate tables to improve query performance
    • Testing aggregate navigation
    • Using Initialization Blocks Repository Variables

    12.Creating Dynamic Repository Variables

    13.Execute Direct Database Requests

    • Accessing database directly

    14.Creating Time Series And Measures

    • Using time comparisons in business analysis
    • Using Oracle BI time series functions to model time series data

    15Creating Dimension Hierarchies And Level-Based Measures

    • Creating dimension hierarchies
    • Creating level-based measures

    16.Providing Security for Groups & Users:


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

    19.Filtering Requests in ORACLE Business Intelligence Answers

    • Introduction to filters in Answers
    • Adding filter prompts to requests
    • Using saved requests as filters

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

    21.Showing Results with Pivot Tables

    • Introduction to pivot tables
    • Formatting pivot tables
    • Setting aggregation rules and building formulas

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 1 month, 1 week
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies