Oracle Business Intelligence Enterprise Edition Overview

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

Check documentation at http://www.oracle.com/technology/documentation/bi_ee.html

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.

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

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.

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

hi Anthony ,

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

thanks,
kamlesh

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

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.

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

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

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

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

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

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

@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

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 “

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.

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

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

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.

Hi,

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

Regards,
Shankar

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

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

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

i want to learn obiee through the ppts

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

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

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

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

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??..

@ 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

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.

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

I need some manuals for OBIEE.

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.

@ 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