Monday, June 16, 2014

Type of views in OBIEE


Component View
Title view
Table
Pivot Table
Graph
Gauge
Funnel
Map
View selector
Static text
Column selector
Narrative view
Legend
Ticker view
Logical sql
Filters

Component View:
Use the component layout view to assemble different views for display on dashboard.
Title View:
A view which shows/displays the title of the analysis.
It will show the name of the report which we are going to save name.
Use the title view to add a title, a sub title, a logo, a link to a custom online custom page, timestamps to the results.
Table:
It shows the combination of data column and its related measure column also.
Use the table view to show in a standard table. Users can navigate and drill down in the results. You can add totals ,customize headings, and change the formula or aggregation rule for a column. You can also control the appearance of a column  and it’s contents, and specify the formatting to apply only if the contents of the column meet certain conditions.

Pivot Table:

Use the pivot table view to take row, column, and section headings and swap them around to obtain different perspectives.  you can drag and drop headings to pivot results , preview them ,and apply settings. Users can navigate through pivot tables and drill down into information. Users can create complex pivot tables that show aggregate and nonrelated totals, next to pivoted data, allowing for flexible analysis. For an interactive result set , elements can placed in pages, allowing users to choose the elements.

Graph /Chart :
Use the chart view to drag and drop columns to layout chart. You can customize the title, legend location, axis titles, and data lables. You can customize size and scale of chart and control colors using a style sheet.

Oracle BI Answers supports a variety standard chart types, including bar charts, column charts, line chart, area charts,pie charts and scatter charts . custom chart sub types include two-and-three-dimensional, absolute, clustered, stackted , combination , a custom.

Gauge:
Use Gauge view to show the results as a gauges, such as dial, bar, and bulb-style gauges.

Funnel:
Use the funnel chart view to show a three dimensional char represents the target and actual values using volume, level  and color. It is useful for depicting target values that decline over time, such as sales pipeline.

Map View:

A map view can show a map of a city with zip codes color-coded by sales performance, while image marker displays the average discount given by order.

View Selector:

Use the view Selector view to select a specific view of the results from among the saved views. When placed on a dashboard, the view selector appears as drop down list from which users can make a selection.


Static Text:
Use the static text view to include static text in results. You can use HTML to add banners, tickers, ActiveX objects, java applets ,links, instructions, descriptions, graphics, and so on in the results.

Column Selector:

Use the column selector view to permit users to dynamically change which columns appear in results. This allows users to analyze data along several dimensions. By changing the facts, users can dynamically alter the content of the results.

Narrative View:
Use the narrative view to show the results one or more paragraphs of text. You can type in a sentence with placeholders for each column in results and specify how should be separated.

Legend:
Use the legend view to document meaning of special formatting used in results, as the meaning of custom colors applied to gauges.

Logical SQL:

Use the logical SQL view to show the SQL generated for the request. This view is useful for trainers and oracle BI Administrators and is usually not included in results for typical users
You  cannot modify this view , except to delete it.







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