OBIEE course contents

  • Introduction to OLAP systems
  • Difference between OLTP systems and OLAP systems
  • Introduction to RDBMS
  • Introduction to Data warehousing and Data Marts
  • Introduction to Data Modeling
  • Need of reporting tools
  • Introduction to OBIEE 11g
  • Overview on
  • Query merging
  • Query customization
  • Query optimization
  • Report customization
  • Report optimization
  • Difference between OBIEE and other reporting tools
  • Overview on OBIEE Server Architecture:
  • Overview on OBIEE Administrator Architecture:
  1. Creation of the ODBC Data Source Name (System DSN) for Different Databases
  2. ODBC connectivity between Database and Oracle BI Administrator
  3. Development of RPD (Repository Directory) files at OBI  Administrator.
  • Repository file (RPD) creation:
  • Physical layer:
  •   Design physical diagram using various physical objects:
  1. Tables
  2. Views
  3. Synonyms
  4. Stored procedures

Import tables from different RDBMS and files systems

  1. RDBMS:
    1. Oracles
    2. SQL server
  • MS-Access, etc
  1. Non-RDBMS (file systems):
    1. Flat files
    2. XML files
  • Excel files
  • Working with multi-dimensional data sources(cubes):
  • SAP-BW
  • Hyperion
  • Micro-soft Analysis cubes
  • Working with CRM Meta data tables
  • Create new physical table in the Physical layer
  • Add new physical columns in the Physical objects
  • Create views in the Physical layer
  • Define primary and foreign keys in the physical table
  • Connection pool verification with ODBC data source name
  • Working with Native drivers
  • Working with type conversion and referential integrity in physical layer.
  • Working with new foreign key and complex join in Physical diagram.
  • Merge two data sources in single physical diagram
  • Connection pool verification with multiple data source connection
  • Assign the permission to the users:
  • BI Administrators
  • BI Authors
  • BI Consumers
  • Create new data source in the Physical layer
  • Enter SQL script:
  • Before connect to database
  • Before query
  • After query
  • After connect to database
  • Business model and mapping layer:
  • Design Business Model Diagram (logical table diagram) using logical fact tables and logical dimensional tables.
  • For standard requirements (detailed),
  • Multi dimensional requirements (summarized) using arithmetic operators, aggregate functions
  • Case statement generation (IF statement, IF-ELSE statement, SWITCH statement
  • Working with various join types( Inner, Left outer, Right outer and Full outer)
  • Creation of global filters
  • Develop the dimensions hierarchies (Multi dimensional analysis)
    1. Level-based hierarchies
    2. Parent-child hierarchies.
    • Create logical dimensional tables
    • Create logical fact tables
    • Working with periodic snap-shot tables
    • Working with transactional grain fact tables
    • Working with fact-less fact tables
    • Working with additive measures, semi-additive measures and non-additive measures
    • Apply the filters

Presentation layer:

  • Arrange the Business Models as subject areas
  • Rename the Meta Data for business user understanding
  • Working with Repository and Session Variables.

Repository variables:Static and Dynamic

Session Variables:System and non-system

      • Working with OBI ODBC client.
      • Overview on OBI server architecture.
      • RPD file configuration at OBI Server Level
      • Cache Management at server level
      • Utilities
      • Security creation of repository
      • Create users and user groups
      • Row updations
      • Internal Process at Server level (conversion of Business query in to SQL query)
      • User alteration at Database level
      • Working with multi-users development (MUDE)
      • Merging of multiple repository files
      • Working with performance tuning
      • Working with consistency check manager
      • Performance tuning
      • Project Development:
      • OLAP Specifications
      • Development of Business Requirement Specifications (BRS)
      • Development of Reporting Requirement Specifications(RRS)

Oracle BI Answers and Interactive Dashboards:

  • Selection of the Subject Area
  • Creation of the Excel Sheet for Reporting Requirement Specifications using Business Requirement Specifications
  • Develop the Request in the Criteria
  • Generate the Reports using Results
  • Develop the logical calculations using advanced tab (set sql format)
  • Reports:
  • Ad-hoc reports
  • Standard reports
  • Dashboard reports.
  • Generate customized reports and override reports in different formats.
  1. Query Optimization
  2. Report Optimization
  • 2-dimensional
  • Multi dimensional
  • List reports
  • Chart reports
  • Line chart reports
  • Bar chart reports
  • Pie-chart reports
  • Cross-Tab reports
  • Setup pages and sections in the cross-tab report
  • Working with various variables
  • Repository
  • Session
  • Presentation
  • Prompts (advance filters)
  • Cascading prompts
  • Dash board prompts
  • Page prompts
  • Testing the prompts with single Go button
  • Working with KPI’s and KPI’s Watch List
  • Working with score cards
  • BI publisher, etc
  • Combined the requests from the different subject areas using set operators like
  • Union, Intersect etc.
  • case statement generation (IF statement, IF-ELSE statement, SWITCH statement
  • Filters (Global and Local filters)
  • Generation of Expression and Aggregated functions
  • Download the reports in PPT and Excel sheet, etc formats
  • Working with direct database connection
  • Working with prompts in direct database request.
  • Working with presentation catalogs.

OBI server administrative activities:

    • Creation of the folder for different requests
    • Scheduling the reports
    • Generation of the iBots (Agents)
    • Dashboard Management, session management, privilege management, etc
    • Tabs creation for multiple Dashboards
    • Creation of the pages for different Dashboards
    • Set permission to others users to work with direct database
  • Interactive Dashboards:
  • Create dash board and page prompts
  • Create pages
  • Create columns as sections in sequential and concurrent
  • Arrange report in the columns and save the dashboard.
    • Installation of Oracle 11g and Configuration Schemas at DBA level
    • Installation of OBIEE 11g.
    • Project Deployment:
  1. Development Environment
  2. Test Environment
  3. Production Environment
  • Working with BI Publisher.
  • Create a JDBC connection to access repository file and database.
  • Create report request
  • Create data model
  • Working with query builder
  • Create row set
  • Create templates
  • Working with list of values(LOVS)
  • Working with parameters
  • Working with Email bursting
  • Working with Analyzer
  • Working with Analyzer for Excel
  • Working with Studio to generate list reports, chart and cross-tab reports.
  • Working Enterprise Management (A middleware fusion control)
  • Upload new repository file
  • Manage the servers
  • Apply roles and policies to the users and user groups
  • Working with Weblogic Administrative Console
  • Working with DAC to configure BI Apps with Informatica