OBIEE Online training

Duration : 30 Hours

Course Outline: RPD Development

Repository Basics

Oracle BI architecture components

Repository structure, features, and functions

Using the OracleBI Administration Tool

Creating a repository

Loading a repository into Oracle BI Server memory

Building the Physical Layer of a Repository

Importing data sources

Setting up connection pool properties

Defining keys and joins

Examining physical layer object properties

Creating alias and select tables

Building the Business Model and Mapping Layer of a Repository

Building a business model

Building logical tables, columns, and sources

Defining logical joins

Building measures

Examining business model object properties

Building the Presentation Layer of a Repository

Exploring Presentation layer objects

Creating Presentation layer objects

Modifying Presentation layer objects

Examining Presentation layer object properties

Testing and Validating a Repository

Checking repository consistency

Turning on logging

Defining a repository in the initialization file

Testing a repository using Oracle BI Answers

Inspecting the query log

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 share measures

Creating rank measures

Using Aggregates

Purpose of aggregate tables in dimensional modeling

Modeling aggregate tables to improve query performance

Testing aggregate navigation

Using the Aggregate Persistence Wizard

Using Partitions and Fragments

Purpose for segmenting data into partitions and fragments

Partition types

Modeling partitions in an Oracle BI repository

Using Repository Variables

Session variables

Repository variables

Initialization blocks

Using the Variable Manager

Using dynamic repository variables as filters

Modeling Time Series Data

Using time comparisons in business analysis

Using Oracle BI time series functions to model time series data

Security

Creating users and groups

Setting permissions for users and groups

Authenticating using a external database

Authenticating using database authentication

Setting query limits and timing restrictions

Setting filters to personalize information

Cache Management

Restricting tables as non-cacheable

Using Cache Manager

Inspecting cache reports

Purging cache entries

Modifying cache parameters and options

Seeding the cache

Setting Up and Administering Usage Tracking

Tracking and storing Oracle BI Server usage at the detailed query level

Using usage tracking statistics to optimize query performance and aggregation strategies

Analyzing usage results using Oracle BI Answers and other reporting tools

Multi-user Development

Setting up a multi-user development environment

Developing a repository using multiple developers

Tracking development project history

Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories

Employing techniques to optimize Oracle BI query performance

Applying Oracle BI repository design principles

Course Topics: ANSWERS & DASHBOARDS

Working with Oracle Business Intelligence Answers

Introduction to OracleBI Answers

Working with requests in OracleBI Answers

Filtering Requests in Oracle Business Intelligence Answers

Introduction to filters in Answers

Adding filter prompts to requests

Using saved requests as filters

Views and Charts in Requests

Introduction to Answers views and charts

Creating a column selector view

Showing Results with Pivot tables

Introduction to pivot tables

Formatting pivot tables

Setting aggregation rules and building formulas

Creating Interactive Dashboards

Introduction to Dashboards and pages

Dashboard Editor UI elements

Composing Dashboard elements

Configuring Interactive Dashboards

Types of Dashboard content

Embedding content in Dashboards

Customizing the Oracle Business Intelligence User Interface

Modifying cascading style sheets

Modifying XML message files

Configuring Guided Navigation Links

Building guided navigation with static links

Building guided navigation with conditional links and sections

Administering Oracle Business Intelligence Presentation Catalog

Maintaining the OracleBI Presentation Catalog

Maintaining security

Understanding security inheritance

Using Oracle Business Intelligence Delivers

Building alerts

Building iBots

Introduction to OracleBI Scheduler

Other Feature we provide:

FAQS

Concentration on performance tuning

Real time scenarios

Certification guidance

Resume preparation

Sample resumes

Interview & certification FAQS

How to face the interview

Class notes which is useful for who is trying for job

Project preparation

Monstercourses providing Best IT online training on all IT major technologies, contact now