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.

Administration Tool (repository)

Administrating Oracle BI

1)Administrating Oracle BI presentation services

All the administratioin changes are do in instanceconfig.xml file.

webconfig
serverinstance

catalogpath /catalogpath
DSN /DSN
configdir /configdir
AllowRememberPassword No /AllowRememberPassword
ConnectionExpireMinutes 3 /ConnectionExpireMinutes
ClientSessionExpireMinutes 1440 /ClientSessionExpireMinutes
UnaccessedRunningTimeoutMinutes 5/UnaccessedRunningTimeoutMinutes
LogonExpireMinutes 180 /LogonExpireMinutes>

CacheMaxExpireMinitues 60 /CacheMaxExpireMinitues
CacheMinExpireMinitues 60 /CacheMinExpireMinitues
CacheMaxEntries 100 /CacheMaxEntries
CookieDomain value /CookieDomain
CookeiExpier Tue,31 Jan 2040 23:59:59 GMT /CookeiExpier
MaxVisiblePages 2000 /MaxVisiblePages
Alerts Enabled No /Enabled \Alerts
DashboardMaxBeforeMenu 10\ DashboardMaxBeforeMenu
/serverinstance
/webconfig


HTML Inputs in OBI Presentation services
View Narrative,View Ticker,View static text,view No Result,Answers:Acess advance tab.

2)Administrating Oracle BI Answers

Chart Image in obi
Charts
DefaultImageType PNG \DefaultImageType
\Charts

ResultRowLimit 9500 \ResultRowLimit

d -Download
f -Print
g -Add to briefing book
m -Modify
r -Refresh

.err for IBot error log file
.log for debug log file

3)Manage device for delivers

-Log in to OBI Presentation services
-settings-Administration
-Click manage device type link
-Click view icon (edit)

Managing Dashboard

-Log in to OBI Presentation services
-settings-Administration
-Manage Intractive dashboard link

About Presentation catalog

save the request,prompts,dashboard,filters ect.

Obiee Installation

Oracle BI Installation

System requirement

* Windows OS
* Oracle 9i or 10i 0r sql
* Third party Installation required for Installing Orable BI
so need to install 1).JAVA SDK 1.5.0 or higher and 2).Microsoft Data access control(MDAC) and 3)IIS Server
* Changing the DEP(Data Excecution Prevention) Setting.
-Windows 2003 and XP the DEP is turned on default for all windows program.So before install obiee turn off
DEP and after installation its change to turn on.
-Path:- Start,control panel,Performance,System,Advance,Perfomance settings,Turn on/off
* Install complete Oracle BI suite with oracle application server containers for J2EE(OC4J)
-Run program setup.exe
-Select complete component type
-basic Installation type installs repository,presentation catalog,XML datasource.
:\oracle BI\server\Repository


Oracle BI components Install

Oracle BI server,Oracle BI presentation services,Oracle BI scheduler,Oracle BI administration tool,
Oracle BI job manger,Oracle BI cluster controller,Oracle BI presentation services plug in,
Oracle BI catalog manager,Oracle BI publisher,Oracle BI client,Oracle BI ODBC driver,Oracle BI JDBC driver,
Oracle BI systems management,Oracle BI disconnected client.

Obiee Basic's

The Oracle Business Intelligence Suite Enterprise Edition Plus (OBIEE) is a comprehensive suite of enterprise BI products,
delivering the full range of BI capabilities including interactive dashboards, full ad hoc, proactive intelligence and alerts, enterprise and financial reporting, real-time predictive intelligence, disconnected analytics, and more.

Oracle BI Server
Oracle BI Answer
Oracle BI Interactive Dashboards
Oracle BI Delivers
Oracle BI Scheduler
Oracle BI Publisher
Oracle BI Presentation Services
Oracle BI Presentation Catalog
Oracle BI Catalog Manager