Home › Data ware Housing › Topics to prepare for OBIEE 11g Certification EXAM(1Z0-591)

Topics to prepare for OBIEE 11g Certification EXAM(1Z0-591)

Posted on May 18, 2014 by oracletechnotalk — Leave a comment

Oracle BI and EPM System Overview

OBIEE Architecture

  • Describe major components of the OBIEE architecture
  • Describe the function of each component

Oracle BI Installation

  • Describe the Installation Architecture for OBIEE
  • Explain system requirements, supported platforms and installation pre-requisites
  • Install OBIEE

OBIEE User Interface Overview

  • Describe the components of OBIEE User Interface
  • Perform Oracle Analysis to construct, modify, and save BI requests
  • Build Dashboards
  • Create BI Delivers

Dimensional Modelling

Oracle BI Repository Overview

  • Describe the three layers of the OBI Repository
  • Use the Administration Tool to view and modify the repository

Build Basic Repository

  • Define a System Data Source Name (DSN) for a data source
  • Build the Physical layer of the Repository
  • Build the Logical layer of the Repository
  • Build the Presentation layer of the repository

Repository Testing and Deployment

  • Describe techniques for testing a repository
  • Validate and test a repository

Complex Repository Modeling

  • Describe Derived Metrics and its use
  • Configure Derived Metrics based on existing logical columns
  • Configure Derived Metrics based on physical columns

Advanced Repository Modeling

  • Create Data Partitioning
  • Create Segmentation of Data
  • Create Time Series Data

Building a Repository with Multiple Sources

  • Add multiple sources to an existing logical table source for a dimension in the business model
  • Add a second table source to a dimension in the business model

Hierarchies and Level Based Measures

  • Create a dimensional hierarchy
  • Use level-based measures
  • Create a rank measure
  • Describe Aggregate tables and the purpose they serve
  • Create Aggregate tables in the OBI repository

Using Variables

  • Explain session variables
  • Describe repository variables
  • Describe initialization blocks
  • Implement a dynamic repository variable

Implementation Methodology and Best Practices

  • Describe the implementation phases

Oracle Business Intelligence Enterprise Edition Security

  • Describe authentication and authorization
  • Describe the different levels at which security is enforced
  • Configure security using Security Manager
  • Configure Query Governing controls

Cache Management & Performance Tuning

  • Explain the purpose of cache in OBIEE
  • Configure caching and manage cache files
  • Develop caching strategies
  • Describe the request and data flow in OBIEE

MS Office Integration

  • Use MS Office Plug-In for OBIEE
  • Describe the required components to enable office integration
  • Install and configure MS office server and client for OBIEE

Spatial Integration

  • Explain Spatial Intelligence and Integration
  • Add Map based visualization to OBIEE

Write Back within OBIEE

  • Describe Write Back capabilities
  • Configure Write Back with OBIEE

Essbase Integration

  • Implement Essbase as a Data Source
  • Configure BI Server Metadata for Essbase
  • Explain Essbase Integration

More Details:

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-591

About

We are very much interested in technical blogging. This blog mainly concentrates on oracle technologies. The posts will be on oracle concepts, interview question and answers, real time scenarios, solutions for queries are provided. This blog will be very helpful for the candidates learning the technology and looking for the job and also for the oracle professionals to update their skills.

Tagged with: , ,
Posted in Data ware Housing, OBIEE, OBIEE certification

Leave a comment

Categories