Association of Computer Technocrats ...

Hai Technocrats,

Today let we go into subject of OBIEE. Now let we see the components of OBIEE

In OBIEE we have many components. Let we see few things

Now we see what are all those

Admin Tool is nothing but Administration Tool. It is the interface to create and manage repository and the logical schema.

Repository - The database repository keeps a local copy of database field definitions

Admin Tool contain 3 layers

· Physical Layer

· Business Model and Mapping Layer

· Presentation Layer

In physical Layer what we will do in this is

- Importing Meta Data

- Configuring Connection Pool

- Creating Alias Tables

- Creating Physical Joins

In BMM Layer what we will do in this is

- We will develop all business logics(means Aggregate functions and some queries and also thing) in it.

- We create Hierarchical Dimensions, Aggregations, Level Based Measures

- Working with calculation wizard

- Creating calculation wizard

In Presentation Layer what we will do in this is

- What every we place in the presentation layer all those things will be visible in Presentation services

- We can build here some security settings.

- Development of Reports

- Development of Filters

- Development of Prompts

- Development of charts

- Development of Pivot tables

- Development of Tickers

- Development of column selectors

- Development of view selectors

Dash Boards are the standard and interface for the majority of users

It allows multiple reports to be displayed in a tabbed interface

The main things in the Delivers is IBOT

IBOT is a Intelligent Bursting Output Tool. It is an utility available in OBIEE and also in Siebel analytics which is used for Reports scheduling as well as alerts sent to the required recipients on different web accessible/communication devices

We have few services

If the services want to work means OC4J

The remaining Catalog Manager, BI publisher, DAC, Disconnected Analytics will be explained later on because all those are real time.

From next parts I will discuss each components in detail with UI.

Small assignment for you people who are following this posting, for reading next article try to go through Dimension table and Fact Tables.

Don’t sit like a Rock

Work hard like clock.