Content of the OBIEE

Dear Friends...

Recently i startd to learning the OBIEE..

i would like to share the Content of the OBIEE.

Data warehouse Concepts  

Ø  Data warehouse

Ø  Data mart

Ø  Basics of Data Warehousing

Ø  What is OLTP and OLAP?

Ø  Difference between OLTP and OLAP

Ø  ·          

Ø  Dimensional Modeling Overview

Ø  Introduction to Dimensional Modeling

Ø  Dimensional table

Ø  Fact table

Ø  Aggregate table

Ø  Star schema

Ø  Snowflake schema

Ø  Star schema Vs. Snowflake schema

Ø  Fact Vs. Dimension table

Ø  Fact Vs. Aggregate Table

Ø  Types of Facts

Ø  Types of Fact tables

Ø  Types of Dimensions

Ø  Level of Granularity

Ø  Grain of fact

Ø  Slowly Changing Dimensions( SCD )

Ø  Normalization

Ø  DE normalization

Ø  OBIEE Overview

Ø  Introduction to Siebel Analytics

Ø  Introduction to OBIEE 10 G

Ø  What is Obiee?

Ø  Advantages of Obiee

Ø  End to End Life Cycle of Obiee

Ø  Types of Reports

Ø  Types of Applications

Ø  Components OF Obiee

Ø  Client Components Of Obiee

Ø  Obiee Architecture

Ø  Difference between Obiee 10g and Siebel Analytics

Ø  Difference between Obiee 10g

Ø  Repository Basics

Ø  What is Meta data?

Ø  Creating a Repository using BI Administration Tool

Ø  Physical, Business Model and Mapping, and presentation layers

Ø  Properties of repository objects

Ø  Online Mode and Offline Mode

Ø  Building the Physical Layer of a Repository

Ø  Physical Layer from Relational Data Sources

Ø  Database Objects

Ø  Setting Up and Properties of Connection Pools

Ø  Physical Tables

Ø  Alias Tables

Ø  Physical Layer Folders

Ø  Physical Joins

Ø  Defining Physical Foreign Keys and Joins

Ø  Using Database

Ø  Viewing Data in Physical Tables or Columns

Ø  Creating and Editing a Column in a Physical Table

Ø  Fragmented Data

Ø  Primary Key and Foreign Key Relationships

Ø  Complex Joins

Ø  Opaque Views

Ø  Business Model and Mapping Layer

Ø  Business Model Objects

Ø  Duplicate Business Model and Presentation Catalog

Ø  Creating and Administering Logical Tables

Ø  Creating and Administering Logical Columns

Ø  Creating and Administering Logical Table Sources (Mappings)

Ø  Dimensions and Hierarchical Levels

Ø  Process of Creating and Administering Dimensions

Ø  Unbalanced (Ragged) and Skip-Level Hierarchies

Ø  Parent-Child Hierarchies

Ø  Subject Areas for Logical Stars and Snowflakes

Ø  Display Folders

Ø  Logical Joins 

Ø  Level Based Measures

Ø  Aggregation Navigation

Ø  Time Series Function

Ø  Presentation Layer

Ø  About the Presentation Layer

Ø  Creating and Customizing the Presentation Layer

Ø  Working with Subject Areas

Ø  Working with Presentation Tables and Columns

Ø  Working with Presentation Hierarchies and Levels

Ø  Setting Permissions for Presentation Layer Objects

Ø  Creating Aliases (Synonyms) for Presentation Layer Objects

Ø  Controlling Presentation Object Visibility

Ø  Utilities and Wizards

Ø  Advantages of Caching Cache Manager

Ø  Using the Cache Manager

Ø  Monitoring and Managing the Cache

Ø  Purging and Maintaining Cache

Ø  Config Files 

Ø  Nqs Config

Ø  Nqs Server 

Ø  Nqs Query 

Ø  Instance Config 

Ø  Variables

Ø  Variable 

Ø  Repository Variables 

Ø  Static and Dynamic

Ø  Session Variables 

Ø  System and Non System Variables 

Ø  Initialization Blocks 

Ø  Row Wise Initialization

Ø  Security

Ø  Data level Security 

Ø  Object Level Security 

Ø  Authentication 

Ø  Authorization

Ø  Users and Groups

Ø  Types Of Authentication 

Ø  LDAP Authentication

Ø  External Table Authentication

Ø  Database Authentication

Ø  Oracle BI Delivers and Database Authentication 

Ø  Oracle BI Server User Authentication

Ø  Analysis

Ø  Types of Views

Ø  Column  Properties

Ø  Filters

Ø  Dashboards

Ø  Dashboard Page

Ø  Dashboard Objects

Ø  Actions and Conditions

Ø  Kpi and Scorecard

Ø  Prompts

Ø  :

Ø  Inline and Dashboard Prompts

Ø  Column Prompt

Ø  Image Prompt"

Ø  Currency Prompt"

Ø  Variable Prompt

Ø  Administering Oracle Business Intelligence Presentation Catalog

Ø  •    Maintaining the OracleBI Presentation Catalog
•    Maintaining security
•    Understanding security inheritance

Ø  Using Oracle Business Intelligence Delivers

Ø  •    Building alerts
•    Building  Agents
•    Introduction to OracleBI Scheduler