OBIEE11G

OBIEE11G COURSE CONTENT

Data Warehouse concepts

  • 1. What is Data
  • 2. Types of Data
  • 3. Types of Databases
  • 4. What is Data Warehouse?
  • 5. Data Warehouse Architecture
  • 6. Difference between OLTP Vs OLAP
  • 7. Types of Columns
  • 8. Types of Tables
  • 9. What is schema and types of Schemas
  • 10. Difference between Star and Snow Flake Schemas

OBIEE Introduction :

  • 1. Why Oracle BI ?
  • 2. What is Oracle BI?
  • 3. History of Oracle BI
  • 4. Oracle BI architecture 11G

OBIEE 11G 1ST LEVEL

Administration

  • 1. Repository Basics
  • 2. Building the Physical Layer of a Repository
  • 3. Building the BMM Layer of a Repository
  • 4. Building the Presentation Layer of a Repository
  • 5. Testing Repository
  • 6. Working with Multiple Logical Table Sources
  • 7. Adding Calculations to Fact Table
  • 8. Creating Dimensional Hierarchies& Level based measures

OBIEE 11G 11ND LEVEL

  • Presentation Services or Analytics
    • 1. Introduction to Presentation Services
    • 2. What is Web Catalog & Instanceconfig.xml
    • 3. Difference between Shared Folders & My Folders
  • Answers
    • 1. Working with OBI Answers
    • 2. OBI Column Properties
    • 3. Style ,Column Format ,Data Format , Conditional Format ,Intraction and Write Back
    • 4. Hide Column
    • 5. Edit Formulas / Report level Calculations
    • 6. Filters
    • 7. Column ,image and Variable Prompts
    • 8. Sorting of Columns
    • 9. OBI 17 Views
    • 10. Combining With Similar Request
    • 11. Direct Database Requests
  • Dashboards
    • 1. Creating Oracle Business Intelligence Interactive Dashboards
    • 2. Working With Dashboard Objects
    • 3. Column , Section ,Link or Image ,Embedded Content ,Text, Folder, Action Link ,Action Link Menu ,Alert Section
    • 4. Hiding or showing Section Dynamically based on condition
    • 5. Working With Dashboard Prompts
    • 6. Column ,Image and Variable Dashboard Prompts
    • 7. Presentation Variables
    • 8. Request Variable
  • Delivers
    • 1. Introduction to Oracle BI Delivers
    • 2. Oracle BI Deliveries Tables
    • 3. Configuring delivery devices
    • 4. Adding delivery profiles
    • 5. Developing Agents
    • 6. Building Alerts
    • 7. Creating Agents Based on Time
    • 8. Creating Agents Based on Time and Condition
    • 9. Creating Chain of Agents
  • Job Manager
    • 1. Monitoring Agents
  • Oracle BI for Microsoft Office
    • 1. Introduction to Oracle BI for Microsoft Office
    • 2. Installation of Oracle BI for MS Office
    • 3. Accessing OBI reports in MS Excel
    • 4. Accessing OBI Reports in MS Power Point
  • Catalog Manager
    • 1. Deploying Dev to test or test to prod
    • 2. Deploying in Offline or Online Mode
    • 3. Catalog Back Up and Restore
    • 4. Providing Permissions
    • 5. Documentation of Web Catalog

OBIEE 11G 111 rd LEVEL

  • 1. Using Aggregate Tables
  • 2. Using Partitions and Fragments
    • a. Value Based
    • b. Fact Based
    • c. Level Based
  • 3. Variables
    • a. Static Repository
    • b. Dynamic Repository
    • c. Repository Initialization Blocks
    • d. System Session
    • e. Non System Session
    • f. Session Initialization Blocks
    • g. Row Wise Initialization Blocks
    • h. Presentation Variables
    • i. Request Variables
  • 4. Time Series Functions
    • a. AGO
    • b. TODATE
    • c. PERIODROLLING
  • 5. Configuring Many To Many Relationships
    • a. Bridge Table
    • b. Helper Table
  • 6. Deploying Oracle Bi application to multiple countries
    • a. Localizing Oracle BI Metadata
    • b. Localizing Oracle BI Data
  • 7. Setting Implicit Fact Column
  • 8. Third Party Reporting Tool Integration
  • 9. Creating Repositories From Multi dimensional Data Sources
  • 10. Security
    • a. Authentication
      • i. LDAP
      • ii. External Table
    • b. Authorization
      • i. Object Level
        • a. RPD
        • b. Web Catalog
      • ii. Data / Row Level
  • 11. Administering Usage Tracking
  • 12. Multi-User Development Environment (MUDE)
  • 13. Utilities
  • 14. Cache Management
  • 15. Optimizing Query Performance
  • 16. Cluster Servers
  • 17. Alias ,Circular Joins & Opaque Views or Select Tables

OBIEE 11 G Advanced New Features

  • 1. Introduction about EM, CONSOLE, ANALYTICS, XMLPSERVER..etc
  • 2. Parent Child Hierarchies
  • 3. Unbalanced Hierarchies
    • a. Ragged Hierarchies
    • b. Skipped Hierarchies
  • 4. Hierarchical Columns and Selection Steps
  • 5. Action Links
  • 6. Creating Simple Action Links
  • 7. Creating Advanced Action Links
  • 8. Master Detail Reports
  • 9. Creating KPI
  • 10. Creating KPI Watch List
  • 11. Creating Scorecards
  • 12. Assign ID columns to descriptive columns
  • 13. Using Lookup Table
  • 14. Horizontal Federation
  • 15. Vertical Federation
  • 16. Combined Horizontal & Vertical Federation

Deployment

  • 1. Moving RPD and Web Catalog from Development server to Testing Server
  • 2. Moving RPD and Web Catalog from Testing Server to Production Server

Migration

  • 1. Under Standing Pre Migration Process
  • 2. Understanding Upgrade Assistant Wizard
  • 3. Migrating from OBIEE 10G to OBIEE 11G
  • 4. Under Standing Post Migration Proces

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Reviews

OBIEE11G

Average Rating

0

0 ratings

5 1

Details

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

ADD A REVIEW

Name
Email
Review Title
Rating
Review Content

Subscribe Email Alerts

If you wish to receive email alerts when new articles, videos or interview questions are posted on PragimTech.com, you can subscribe by providing your valid email.