OBIEE Online Training


OBIEE  Online Training By IT Experts

Vision Online Training offers OBIEE Online Training.Our OBIEE trainers are highly talented and well experienced trainers. Our OBIEE online training is one of the Best online training in India.All our students were happy With our online training and able to find Jobs quickly in USA, UK, Singapore, Japan, Europe. online training is your one stop solution to learn OBIEE at your home with flexible schedules.

Vision Online Training offers the OBIEE Online Training Course

OBIEE Online Training Concepts :

OBI ARCHITECTURE

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

OBI COMPONENTS

  • OBI Administration Tool
  • OBI Answers
  • Intelligence dashboards

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

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

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

BUILDING THE PRESENTATION LAYER OF A REPOSITORY

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

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

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

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

BUILDING THE PRESENTATION LAYER OF A REPOSITORY

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

TESTING AND VALIDATING A REPOSITORY

  • Checking repository consistency
  • Defining a repository in the initialization file
  • Adding Multiple Logical Table Sources
  • Adding multiple logical table sources to a logical table
  • Specifying logical content

ADDING MULTIPLE LOGICAL TABLE SOURCES

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

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

CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES

  • Creating dimension hierarchies
  • Creating level-based measures

CREATING & USING AGGREGATES

  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • Testing aggregate navigation

Using Initialization Blocks Repository Variables

CREATING DYNAMIC REPOSITORY VARIABLES
EXECUTE DIRECT DATABASE REQUESTS

  • Database Accessing directly

CREATING TIME SERIES MEASURES

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

CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES

  • Creating dimension hierarchies
  • Creating level-based measures

Providing Security for Groups & Users:
ANSWERS (REPORTS)
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

FILTERING REQUESTS IN ORACLE BUSINESS INTELLIGENCE ANSWERS

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

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

SHOWING RESULTS WITH PIVOT TABLES

  • Pivot tables Introduction
  • Pivot tables Formatting
  • Setting aggregation rules and building formulas

Our OBIEE Online Training batches start every week and we accommodate your flexible timings.

Vision Trainings provides online training for various courses like Datastage Online Training,Taradata Online Training,Pentaho Online Training,BOXI Online Training,Microstratgy Online Training

Home    About Us    Contact Us    Sitemap
ContactUs.com