ORACLENERD: Learning Oracle Business Intelligence (OBIEE)

Learning Oracle Business Intelligence (OBIEE)

I learned how to edit a user in OBIEE without breaking anything (thus no need for a new counter Jake).

At first I thought it would be done through the web application only to find no edit button associated with the user. I had to go through the online repository, update the user, and commit those changes. Not really sure what all that means yet, but it's a start.

I had a crash tutorial on this last week as the person I replaced was off to start his own company. OBIEE is a vast, vast world.

Where does one go to learn OBIEE from the bottom? OTN naturally. The Oracle By Example series is excellent so that's where I started.

First up, Creating a Repository Using the Oracle Business Intelligence Administration Tool . I've made it through the Physical Mappings and the Business Mappings so far, one more section to go. I can't say I completely understand all the lingo, but I'll catch on sooner or later. I'm more concerned with the basics of support at this point.

Updated 2/28/2010
Blogs
- The RittmanMead blog is the premier online resource for all things OBI EE. It can be found here.
- John Minkjan over at OBIEE 101 has quite a bit of information. He posts often and detail posts. I've already been able to reference individual posts a number of times.
- gerardnico There are some great resources here.
- Christian Berg - who has helped me quite a bit writes over here.
- rnm1978 - same goes for this guy. Very helpful articles.
- OTN Forums

BI Architecture Series
This just started recently by Mark Rittman, I'm looking forward to future posts in this regard:

Inside the Oracle BI Server Part 1 : The BI Server Architecture
Inside the Oracle BI Server Part 2 : How Is A Query Processed?
Inside the Oracle BI Server Part 3 : BI Server In-Memory Joins

How To

Installation

Install 10.1.3.4 on Oracle Enterprise Linux 5, Update 4 - Details on issues with installation (using VirtualBox)
Uninstall on Oracle Enterprise Linux 5, Update 4
Install 10.1.3.4 on Windows Vista Ultimate
Install on Windox 7, x64

Miscellaneous
My articles on said subject can be found here.

I'm sure as time goes on my tastes will ebb and flow. I'll update as appropriate.

Labels: bi, datawarehouse, obiee, oracle

¶ 1/05/2009 11:02:00 PM

Comments:

Hi Chet,

it looks like you got the best sources lined up there.

Should you stumble upon something weird, Venkat's always a good place to have a look as well: http://oraclebizint.wordpress.com/

Otherwise most of us are anyways in the OTN forums all the time ;-)

Cheers,
Christian

# posted by

Christian Berg : January 6, 2009 5:15 AM

I have been doing a bunch of DW work lately, too, though not -- ahem -- Oracle brand. ;-)

Because of that, I have been listening a bit more closely to their BI people and I think they are making a lot of sense lately. I'll try to dig up some resources on this, but they are doing a good job of articulating what they mean by BI versus Analytics versus generic Reporting, etc.

In the end that may make less of a difference technically, but it helps in the board room. (Do people actually use 'board rooms' any more?)

# posted by

Ted Simpson : January 6, 2009 5:15 AM

I'll check that one out Christian, thanks!

Forums...almost forgot. That's how I learned ApEx. That'll be the first place I go when I have questions.

# posted by

oraclenerd : January 6, 2009 9:40 AM

Ted,

Sinner. You know you aren't allowed to use those "other" tools! ;)

# posted by

oraclenerd : January 6, 2009 9:41 AM

Hi Chet,

I've been tasked to do everything you have done here. The basic set up works. Now the problems:
Environment: BI Server on RH 5.3, client tools on Windows XP Pro. All the general processes work, I have connectivity, etc. The wrinkle in this setup is that in mid-stream front office suggested OBIA rpd instead of the default paint.rpd. A database was created with the requisite schema.

When logging into the analytics, the dashboards are list on the top like they are supposed to be. However, when I click to open one up, this error happens:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 3135, message: ORA-03135: connection lost contact at OCI call OCISessionBegin. [nQSError: 17014] Could not connect to Oracle database. (HY000)

Where is this being set? I thought I double check everything, but possibly the odbc.ini on the server(?) side??? There are a number of issues. Any help you can give to lead me to the light would be greatly appreciated.

Rgds,

laomgm

# posted by

laoma : March 2, 2010 2:52 PM

laoma,

drop me a line at chet@oraclenerd.com, might be able to help you more quickly that way. One of us can post the result once it is resolved.

chet

# posted by

oraclenerd : March 2, 2010 2:54 PM