Oracle Business Intelligence Enterprise Edition Overview

Oracle Business Intelligence Enterprise Edition (BIEE) consist of component which were earlier part of Siebel Analytics from siebel.

  • Business Intelligence consists of two parts Infrastructure Component & Business Intelligence Applications.

Business Intelligence Infrastructure consist of following components
i)   Business Intelligence Server
ii)  Business Intelligence Presentation Services
iii) Business Intelligence Presentation SErvices Plug-in
iv)  Business Intelligence Scheduler
v)   Business Intelligence Administration Tools
vi)  Business Intelligence cluster controller
vii) Business Intelligence Client
viii)Business Intelligence ODBC Driver
ix)  Business Intelligence JDBC Driver
x)   Business Intelligence System Management
xi)  Business Intelligence Catalog Manager
xii) Business Intelligence Job Manager
xiii)Business Intelligence Publisher
xiv) Business Intelligence Disconnected Client
xv)  Business Intelligence Publisher Desktop
xvi) Business Intelligence Open Intelligence Interface
xvii)Business Intelligence Office Plug-in
xviii) Business Intelligence Briefing Book Reader

Oracle Business Intelligence Install Type
————————————————-
In order to install Oracle BI infrastructure component you have 7 options
1. “Complete” install components i) to xiii)
2. “Oracle BI Server” install component i, iv, v, vi, vii, viii, ix, x, xii
3. “Oracle BI Presentation Services” install component ii, iii, vii, viii, x, xi
4. “Oracle BI Client tools” install components v, vii, viii, ix xi, xii
5. “Oracle BI Disconnected Clients” installs component xiv
6. “Oracle BI Publisher” installs component xiii
7. “Custom” any one of above i) to xviii)

Oracle Business Intelligence Installion Option
——————————————————–
There are two kind of install Basic & Advanced

Basic Installation of BIEE
–This is used if you are not using Oracle Application Server web server
–This type of install require J2EE so any web server which support J2EE can be used for basic BI installation
–This require J2SE 5 or higher , like JDK 1.5 or higher (not JRE)

Advanced Installation of BIEE
— This type of installation require Oracle 10g Application Server (10.1.3.X or higher)
— If you need Single Sign-On with BIEE you need this type of installation

Related Document
———————-
Business Intelligence Installation & Configuration Guide PDF

Installation of Business Intelligence on Linux coming soon …

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

37 comments
PrasadNarvekar says January 25, 2008

Hi Atul,
I am new to OBIEE and want to know more about it’s installation. Can you please let me know the link which explains the architecture of OBIEE? Also where does database comes into picture in whole installation of OBIEE? Can we use Informix with OBIEE?

Thanks in Advance

Regards,
Prasad

Reply
spai says March 17, 2008

I have some confusion between BIEE and BIDISCOVERER.

I have set up a OWB server for ETL , creating target OLAP cubes etc.

For the presentation and dasboard I am going with BI discoverer integrated with APPS server.

How different is BIEE from BI discoverer?
Which is better / easy to configure and administer.

Reply
Anthony says April 17, 2008

Hi,
I am new to OBIEE and want to know more about it’s installation. Can you please let me know the link which explains the architecture of OBIEE? Also where does database comes into picture in whole installation of OBIEE? Can we use Informix with OBIEE?

Thanks in Advance

Regards,
Anthony

Reply
Syed says June 23, 2008

Dear Atul,

Our Envirnoment is R12 on solaris 10 with Discoverer, i want to IMplement SSO on Oracle Appilication, When user Connect to Oracle Application if they want Discoverer reports its acessing the BI Url thorugh Oracle Application and Opening the Page with Login Cerditantials. So we want SSO over here , Once User Login No need to relogin Again.
i have Read Meatalink DOCs (373634.1 ,376811.1), but i am littel bit confuse . as per the Doc manadatory is OID,SSO Disocverer ok. when i run runInstaller (Select Installtion Type) 1)Identitiy mangmt and metadat rep 2) indentiy manamgnt 3) metadata Rep
here i confuse wither what i have to use choice above 1,2,3
or can we use R12 database.

bottom pointmy req is want discoverer should be acess through oracle application once login.
Please give littel time Extra to this issue.
i willbe thk full to u.

Reply
Atul says June 23, 2008

Syed,
You wish to integrate discoverer/BI (10g) isntalled on standalone oracle_home (10g AS) and EUL of this Discoverer/BI is in 11i/R12 database.

You wish to integrate sso with disco and 11i/r12 so that user loged in to apps 11i/R12 don’t have to login again to access discoverer workbooks or other parts.

You need to install SSO/OID for this and repository to hold SSO/OID data (MR). IdM 10.1.4 is latest certified

Identity Management will give you only OID & SSO (No MR) but for this you should already have Repository installed and configured somewhere

So go for MR+Identity Management option this will install database (MR) to hold oid & sso data, OID & SSO processes.

Then integate SSO with Disco & 11i/R12 using docs mentioned by you.

In my opnion don’t use 11i/R12 database to hold MR for OID & SSO (not recommended), select option 1

Reply
kamlesh.jethwa@gmail.com says July 7, 2008

hi Anthony ,

I have good info for your doubts on OBIEE.
hope you find helpful.
http://www.infopurple.com/obiee-installation-steps

thanks,
kamlesh

Reply
Vani says August 7, 2008

Hello Everyone,
I have an interview in 5 says OBIEE.Im wondering if anyone got interview questions regarding Siebel Analytics or OBIEE.I would relly appreciate for the help

Thank You,
Vani

Reply
Paul says September 29, 2008

Hi Atul,

By any chance, have you done any integration of Discoverer with OBIEE? I am looking for some doc of using Discoverer from OBIEE. Is it possible to point OBIEE Discoverer to EUL in EBS Suite?

Thanks for your help.

Reply
srikanth says November 17, 2008

Hai Atul I am new to obiee i have interview in a week as fresher. can i know which type of questions they ask please send some sample questions
regards
srikanth

Reply
sri says December 2, 2008

Hi Atul,

I have installed OBIEE on linux and I able to login to the OBIEE also.But whenever I restart and start the oc4j service — throw the following error
“SEVERE: Exception occured while loading JNIDLL: perfjni with java.library.path = /u04/OBIEE/OracleBI/server/Bin:/u04/OBIEE/OracleBI/web/bin
Dec 2, 2008 3:16:40 PM oracle.bi.analytics.management.monitoring.PerfDllJNI
SEVERE: Exception details: /u04/OBIEE/OracleBI/server/Bin/libperfjni.so: /u04/OBIEE/Oracl
eBI/server/Bin/libperfjni.so: cannot open shared object file: No such file or
directory (Possible cause: architecture word width mismatch)
08/12/02 15:16:40 java.lang.Exception: /u04/OBIEE/OracleBI/server/Bin/libperfjni.so: /u04/OBI

EE/OracleBI/server/Bin/libperfjni.so: cannot open shared object file: No such file or direct
ory (Possible cause: architecture word width mismatch)

Can you please guide me with this.

Thank you,
Sri

Reply
Atul Kumar says December 3, 2008

Sri,
This in my opinion is Bug in Oracle/BI code. Ensure that you are on certified O.S. and then raise SR with Oracle via metalink3

Reply
bala says January 20, 2009

Hi Atul,
I wanted SSO enable my OBI EE installation.

please guide me which installation i have to choose & the steps to configure SSO for the same.

thanks,
bala

Reply
Suren says May 8, 2009

Hi Atul,

Great job. Hats Off to all your efforts.

I have a question on OBIEE. In order to eliminate parallel servers I would like to install OBIEE using VMware.

Is it possible? Do you have any document which contain the steps to do such an installation?

Thanks in advance.

Thanks,

Ramana

Reply
mittal79 says May 21, 2009

Hi Atul,
We have to install OBI for demo purpose in our organization with EBS 12.1.1 I have seen in 12.1.1 documentation that there are some Intelligence stuff which comes with 12.1.1. I am not sure about what comes with this new release or it’s a separate product which we need to install separately like OBIEE and then OBI applications. I am not able to find any hint on Oracle website and Google that Release 12.1.1 has intelligence inbuilt or not. If you can guide here about do we have to install OBIEE separately with R12.1.1 and integrate, that will be great of you.
Regards,
MiTTaL
Melbourne – Australia

Reply
Atul Kumar says May 22, 2009

@Mittal,

OBIA is separate product which you need to install separately (different from OBIEE and R12); Oracle BI application is prebuilt BI solutions (using OBIEE) to gain more insight and greater value from a range of data sources and applications including Oracle E-Business Suite, PeopleSoft, Siebel, JD Edwards, and third party systems such as SAP.

Oracle Business Intelligence Applications overview
http://www.oracle.com/appserver/business-intelligence/bi-applications.html

Download BI Application version Applications 7.9.6 from here
http://www.oracle.com/technology/software/products/ias/htdocs/101320bi.html

Reply
mittal79 says May 22, 2009

Hi Atul,

Thanks for the information and i really appreciate that. I still have some doubt about release 12.1.1 in regards to various analytics.
If you check this below link at oracle website it states that new release 12.1.1 has analytics inbuilt. Do we still have to integrate OBI applications with New EBS for some other more smart intelligence 🙂 If yes, do u some idea about the difference in the standalone OBIA and inbuilt stuff. isn’t this standalone stuff for application like peoplesoft etc..

Regards,
MiTTaL

http://www.oracle.com/applications/e-business-suite-release-12-1.html

“Achieve fast time to value by reducing deployment time and lowering overall total cost of ownership with analytics seamlessly integrated to transaction systems including Procurement & Spend Analytics, HR & Talent Management Analytics, Project Analytics, and Federal Financial Analytics “

Reply
meetchakri says July 29, 2009

i am having oracle 11i on windows xp. i have installed the obiee and also the application server 10g on the same machine. how to integrate the ebs so i can see the ebs data on the dashboards. please advice.

Reply
girish says August 10, 2009

Hi Atul,

BI Server starting successfully with 30-40
errors

log details issue: NQServer.log

[nQSError: 13011] Query for Initialization
Block ‘Next Project variables’ has failed.

[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCILogon.

I have installed OBIEE and OBIA on Linux successfully.

1. I have installed OBIEE 10.1.3.4 with Demo data.

2. I Installed OBIA, Applications on top of OBIEE.

I am able to Login into BI Publisher
and Analytics Dashboards successfully, none of
the dashboard work.
I get DB connection errors.

regards
girish

Reply
Jayesh says August 13, 2009

Please provide Oracle 10.3 r3 certification information and preparation document links.

Reply
askingspark says April 24, 2010

Hi Atul,

I appreciate your efforts on sharing your knowledge. I am new to OBIEE domain. I was trying to install OBI Standard Edition One. However all my attempts failed because of errors like ‘SID already exists. Create a new SID.’ I would highly appreciate if you could outline the steps to install OBISE. Also if you know of any study material for OBI other than one listed on Oracle…please let us know…
Thanks.

Reply
Shailesh says June 7, 2010

Hi,

Please help me to find the difference between OBIEE and OBIA.

Regards,
Shankar

Reply
Shailesh says June 7, 2010

Hi Girish,

iam very new to OBIEE.
Please help me to install OBiee on my windows pc. and how can i integrate OBIA with OBiee .

Please help me with the steps.

Regards,
Shailesh

Reply
Shailesh says July 21, 2010

Hi,
our platform is Oracle 10g Forms and Reports deployed on Oracle 10g App Server.
Our goal is to implement Oracle BI Dashboards on this environment.

Our Project Goal is to demonstrate management with our application financial dashboards.

To achieve this we have installed OBIEE, OBIA and DAC and Informatica. as per the config doc i configured all components.

We also have 2 queries

1. To give demonstration to our Management can we use Oracle R12.1.1 as application in DAC and run the ETL loads to view data in Presentation services.Is this the correct way ?

2. As per the updates in forums i came to know that usage Universal container is rare and time consuming.

Now can you please suggest any other easy and appropriate methods to implement Oracle BI
that is suitable to our platform.

Regards,
Shailesh

Reply
minakshi says July 26, 2010

Hi Atul: I have one question regarding Oracle BI Publisher.
I schedule one report in BI publisher and in history its showing status as ‘Running’ from a long time, I want to terminate that process and want to stop the running report.
But as I don’t no much about OBIEE I am unable to do that. Could you please help me with this.

Thanks
Minakshi

Reply
gopal says September 2, 2010

i want to learn obiee through the ppts

Reply
SUMA says November 3, 2010

Hi,
every budy,
i need help on obiee,
i installed and configured DAC,
how to practise DAC, isany one having material on DAC pls help me

PLSSS I WANT DAC LAB PRACTICE MATERIAL

WITH REGARDS
SUMA

Reply
prasad says November 18, 2010

Hi,
I am new to OBIEE and want to know more about it’s installation. Can you please let me know the link which explains the architecture of OBIEE? Also where does database comes into picture in whole installation of OBIEE? Can we use Informix with OBIEE?

Thanks in Advance

Regards,
prasad

Reply
Atul Kumar says November 22, 2010

@ Prasad,
For OBIEE 11g documentation check http://download.oracle.com/docs/cd/E14571_01/bi.htm

Reply
avinash says April 8, 2011

Hi Atul,

I appreciate your efforts on sharing your knowledge.
I’m new to BI Apps.I’m trying to implement cloning (process of copying an existing installation to a different location while preserving its configuration) of BI Apps. Currently, I have a full instance with data.

I want to create test and Prod env with the existing dev env (no installations).

If you have any idea for BI cloning is also helpful for me. Please provide me any guide or suggestions.

Thanks & Regards
-Avinash

Reply
Gayathri says May 23, 2011

Hi,

I’m an aspirant in OBIEE and trying to fit into a job as OBIEE Developer. So, in this process, I’m coming across many terms that sounds so synonymus like: “OBIEE and OBIA”, “CRM & ERP” etc.. Can anyone help me in this??..

Reply
Atul Kumar says May 23, 2011

@ Gayathri ,
Yes, I can understand as I had similar doubts during initial years of my career

OBIEE – is tools/software for Business Intelligence which helps in creating/ developing/ customizing BI

OBIA – Oracle Business Intelligence Application (pre-packaged application for Intelligence )

CRM and ERP are generic terms for customer relationship management & enterprise resource planning software with overlap with in oracle from Oracle, Siebel, Peoplesoft and JDedward offerings

Reply
Gayathri says May 23, 2011

Thank you so much for your reply Atul..

Though I’m not a master in using OBIEE Adminstration and Reporting tools, I am good at both of them. But, my problem is: I’m really not understanding the actual requirement due to the similar terminology. Unless I get a chance to work on some real time projects, I think this confusion will not go.

So, can you please help me how can I get those manuals.

Reply
Atul Kumar says May 23, 2011

@ Gayathri,
Which manuals ? Do you mean OBIEE or for OBIA ?

Reply
Gayathri says May 23, 2011

I need some manuals for OBIEE.

Reply
Nnf says January 3, 2012

Dear
we install OBII in the server and we are 4 member working in the same project and want to create RPD and only one of the team have access to the server how the rest of team can create RPD and upload it to the server.

Reply
Atul Kumar says January 3, 2012

@ Nnf,
There can be only one active repository per OBIEE instance.

If you have multiple users all developing and working on same RPD then you can use Multi User Development (MUD)

More information here

http://docs.oracle.com/cd/E21764_01/bi.1111/e10540/lifecycle.htm#BIEMG3239

Reply
Add Your Reply

[i]
[i]
[i]
[i]
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]