OBIEE Course Curriculum

Techno Level 1: Basic Level                                                                           

1. Overview of OBIEE Real Time Project

   1.1. Why OBIEE?

   1.2. What is OBIEE?

   1.3. OBIEE Real Time Project Types

           1.3.1. OBIEE without ETL

                           (Directly from OLTP or any Database)

              1.3.2. OBIEE with ETL

                      (OLAP using ETL Tools like Informatica, DAC, and ODI)

           1.3.3. OBIEE with OBIA or Oracle BI Apps

                      (Using OBIA 7.9.6.4, OBIA 11.1.1.10.1)

  1.4. OLTP vs OLAP

  1.5. OBIEE 11g Installation

          1.5.1. Certification Matrix

          1.5.2. Downloads (OTN & edelivery)

          1.5.3. Installation Types

          1.5.4. Installation

                    1.5.4.1. On Windows Server

                    1.5.4.2. On Linux Server

          1.5.4. Bugs and Patches (Oracle Support)

2. OBIEE Introduction

    2.1. History of OBIEE

    2.2. Components and Types

    2.3. Data Modelling Elements

           2.3.1. Columns

           2.3.2. Tables

           2.3.3. Schemes

3. BI ADMIN TOOL

    3.1. Physical Layer

           3.1.1. Hands on Main Objectives

    3.2. BMM Layer

           3.2.1. Hands on Main Objectives

    3.3. Presentation Layer

           3.3.1. Hands on Main Objectives

    3.4. Validating and Testing a RPD

4. OFMW Enterprise Manager

    4.1. Overview

    4.2. Deploying or Loading RPD and Catalog

    4.3. Disabling Cache

    4.4. Setting up Query Log

5. BI Analytics

    5.1. Accessing Analytics for First Time

    5.2. Creating or Developing First Analysis

    5.3. Enhancing an Analysis by Adding views

6. BI Interactive Dashboards

    6.1. Exploring and Editing My Dashboard

    6.2. Building or Developing First Dashboard

    6.3. Catalog

Techno Level 2: Experienced Level

7. OBIEE Architecture

    7.1. Physical Architecture

    7.2. Logical Architecture

8. Weblogic Server (WLS) Admin Console

    8.1. Overview

    8.2. Creating a user

    8.3. Creating a group

           8.3.1. Assigning a user or users to a group or groups

    8.4. Creating an application role in OFMW EM

           8.4.1. Assigning a group or groups to an application role or roles

    8.5. Deleting users, groups and roles.

9. BI ADMIN TOOL

    9.1. Adding Multiple Sources

    9.2. Calculations

           9.2.1. Calculations based on logical columns

           9.2.2. Calculations based on Physical columns

           9.2.3. Calculations using Calculations wizard

    9.3. Dimensional Hierarchies

           9.3.1. Level based Hierarchy

           9.3.2. Time Dimension Hierarchy

           9.3.3. Unbalanced Hierarchies (Ragged and Skipped)

           9.3.4. Parent-Child Hierarchy

    9.4. Level Based Measures (LBM)

    9.5. Modelling Time Series Data

    9.6. Variables             

           9.6.1. Repository Variables

           9.6.2. Session Variables

           9.6.3. Presentation Variable

           9.6.4. Request Variable

           9.6.5. Global Variable     

10. BI Analytics

      10.1. Working with analyses and properties

      10.2. Working with filters and Prompts

      10.3. Working with Views

      10.4. Advance features of Analysis

              10.4.1. Cross Subject Analysis

              10.4.2. Combining the similar request

11. BI Interactive Dashboards

     11.1. Working with Dashboard and properties

     11.2. Dashboard Prompts

     11.3. Catalog Manager

12. BI Delivers

      12.1. Configuration of Scheduler and Mail Server.

      12.2. Creating a Delivery Device

      12.3. Creating a Delivery Profile

      12.4. Creating and Scheduling an Agent (iBOT)

      12.5. Job Manager

13. Security

      13.1 Authentication

              13.1.1. LDAP Authentication

              13.1.2. External Table Authentication

              13.1.3. SSL and SSO Authentication

      13.2 Authorization

              13.2.1. Object Level

              13.2.2. Data Level or Row Level

              13.2.3. Precedence and Inheritance

      13.3 Direct Database Request (DDR)

14. Performance Tuning

      14.1. Cache management

      14.2. Connection Pools

      14.3. Aggregate tables

      14.4. Partitioning and Fragmenting of Data

      14.5. Tuning Thread pooling using WLS Admin Console

      14.6. Indexing on Tables

      14.7. Usage tracking

15. Troubleshooting

      15.1. Troubleshooting using logs

      15.2. Troubleshooting using BI Admin Tool

      15.3. Troubleshooting using OFMW EM

      15.4. Troubleshooting using WLS Admin Console

      15.5. Troubleshooting using Configuration files

16. BI Publisher

      16.1. Overview

      16.2. BI Publisher Administration

      16.3. BI Publisher Reports

               16.3.1. Reports based on any Database

               16.3.2. Reports based on OBIEE Reports

               16.3.3. Reports based on OBIEE Subject Area

               16.3.4. Reports based on RTF Templates

Techno Level 3: Interview Level (Technical +SME+ Managerial Rounds)

Note: At this level, Real Time Scenarios(S), Interview questions (I) and Advanced

          topics (A) and Topic wise Expected questions (E) are discussed from OBIEE,

          OBIA, BIP, SQL, Informatica, DAC, ODI and Linux.

Interview Level – Real Time Questions And Answers with Explanation

I.19. On a scale of 5, how you rate yourself in BI Admin Tool? [OR]

      On a scale of 10, how you rate yourself in OBIEE? --- Oracle India  

      (Hyderabad), PWC (Bangalore), Capegemini (Mumbai), Accenture

      (Kolkata),Dubai Islamic Bank (UAE).

S.2. What are the hard or tough reports or requirement you had done? --- Oracle

       India (Hyderabad), Oracle India  (Bangalore), Dell (Bangalore),British

       Telecom (Bangalore), Accenture (Kolkata), Deyaar (Dubai).

    I. Do you have done any performance tuning? How?----- Oracle India 

       (Bangalore), Dell (Bangalore), PWC (Bangalore).

S.47. If copy and paste options are disabled how will you do changes to a report?----

        Genpact (Hyderabad)

A.I. Did you enable cache in your project? [OR] What are the types of cache? ----

       Oracle India (Bangalore), Accenture (Kolkata),TCS (Bangalore)

I6. What is a degenerate dimension? ------ Capegemini (Mumbai)

I7. What is a junk dimension?------ Sapient (Bangalore)

I.52. Write a query in SQL to count duplicates in a table and then deleting duplicates.-

         --- PWC (Bangalore), British Telecom (Bangalore)

I.14. Do you have done code migration? ---- Oracle India (Bangalore), Dell

        (Bangalore), PWC (Bangalore), Accenture (Kolkata).

I.43. Can we assign different presentation tables to different users? How? ------ PWC

        (Bangalore), Oracle India (Bangalore), Dubai Islamic Bank (DIB) (UAE)

I.47. In dashboard can we hide certain reports based on a condition? How? ------

        Accion Labs (Malaysia)

I.S.48.Can we add images to analysis or report? How?----- Raqmiat (Dubai), ITC

      Infotech (Bangalore)

…….

More Questions…………………………...100+ Interview Questions with Answers

Interview Level – Expected Questions And Answers with Explanation

I.Introduction:

1. What is the end to end life cycle (SDLC) of OBIEE?

3. What are the OBIEE 11g components and types?

4. What are the types of tables and columns in OBIEE?

8. What is meant by conformed dimensions? ------Genpact (Hyderabad), TCS

      (Bangalore)

9. Difference between snow flake and star schemas. ------ Oracle India (Hyderabad),

    Brillio (Bangalore), Genpact (Hyderabad)

10. What is surrogate key? —Genpact (Hyderabad)

----------

II.BI Admin Tool(RPD)

          A.Introduction:

1. What is use of BI admin tool?

2. What do you mean by metadata and RPD?

3. What are the three layers in RPD?----- Deyaar (Dubai),ITC InfoTech,Tech

    Mahindra (Hyderabad)

4. What did an RPD stores and what is it size general and in your Project? -----

    Genpact (Hyderabad), British Telecom (Bangalore),HCL (Chennai)

--------

          B.Physcial Layer:

1. What are objects of physical layer?

2. Is OBIEE supports multiple databases?

3. Can we access all the tables of a database using one connection pool?

4. What are the connection types to import metadata in RPD?

6. What are the steps of importing metadata from DWH to RPD?

7. What are the joins in OBIEE 11g?-----Genpact (Hyderabad),HCL (Chennai),

    Oracle India (Hyderabad), Sapient (Banglore),KPMG (Bangalore)

-------

          J. Modelling Time Series Data

1. Are there any analytical function in OBIEE?

2. What are Time series functions and uses?------- Capegemini (Pune)

3. What is the analytical function used in period rolling function in OBIEE 11g?

4. What is Chronological key? ---------TCS (Bangalore),HCL (Chennai)

----------

More Excepted questions…………………...………….200+ questions and answers

Additional Topics:

A1. OBIA 7.9.6.4

       A1.1. Architecture

       A1.2. Installation and Configuration

       A1.3. Informatica

       A1.4. DAC

A2. OBIA 11.1.1.10.1

       A2.1. Architecture

       A2.2. Installation and Configuration

       A2.3. ODI

A3. SQL

A4. Linux