Variables

OBIEE Variables

There are 3 types of variables in OBIEE

Presentation Variable

Repository Variable

Session Variable

Presentation Variable

Repository Variable

o Dynamic

o Static

Session Variable

o System

o Non System

OBIEE Architecture

OBIEE Architecture

OBIEE has a complex, SOA-based architecture consisting of a BI Server, BI Repository, BI Presentation Services, BI Scheduler and BI Java Host process.

The BI Presentation Services and BI Server are the two key components of the OBIEE Architecture. The BI Server connects to a wide variety of data sources, but integrates the data it retrieves using a mapping held in a local data store, the BI Repository, so that to its client applications it appears to contain a single table with a large number of columns. This semantic view of the enterprise’s data is presented to end users by the BI Presentation Services and is the basis for constructing ad hoc queries.

OBIEE Architecture consisting of

•  BI Server
• BI RepositoryBI Presentation Services
• BI Scheduler
• BI Java Host process

Oracle BI has two main components:

• Oracle BI Presentation Services
• Oracle Business Intelligence Applications

Oracle BI Presentation Services consists of:

•  OBI Intelligence Answers
• OBI Interactive Dashboards
• OBI Delivers

Oracle Business Intelligence Applications

An Oracle BI application consists of pre-built, industry-specific Oracle BI interactive dashboards and Oracle BI reports that are built using industry best practices and address key functional areas within an organization. Oracle BI applications are integrated with operational applications to provide business metrics in reports, in context with an organization’s business function and industry.

Oracle BI applications include Extract Transform Load (ETL) routines to extract, transform, and load data into the Oracle Business Analytics Warehouse.

Different Views in OBIEE

Report Views:-

1.Table
2.Pivot Table
3.Title
4.Chart
5.Gauge
6.Filters
7.Compound Layout

Other Views:-

Column Selector,View Selector,Legend,Funnel Chart,Narrative,Ticker,Static Text,No Results,Logical SQL,Create Segment,Create Target List.