Monday, April 4, 2011

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.

Friday, April 1, 2011

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