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 *

    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. keen Technologies also verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.

    You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.

    Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, India and other parts of the world.

    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

    Job Support

    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


    This web site or team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information


    +91 9989754807

    Popular Courses


    Keen Technologies offering training in cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Texas, Chicago, San Francisco, Dallas, Washington, New York, Houstan, Atlanta, Orlando, Boston, Toronto, Ottawa, Windsor, Australia, Dubai, Leeds.


    WhatsApp us whatsapp