OBIEE 11g is going to be officially launched on 7th July (this year!) in London: Launch Event: Introducing Oracle Business Intelligence Enterprise Edition 11g
h/t to Twitter and blogs (including an Oracle-branded one) this morning. Good news travels fast! :-)
Looks like John Minkjan won the bet, did he know something we didn’t? ;-) (although is “Launch” the same as “GA”?)
Here’s my presentation “Performance Testing and OBIEE” that I gave at the RittmanMead BI Forum 2010: Performance Testing and OBIEE.pptx
It’s a Powerpoint 2007 file (pptx) for which you may need the Microsoft PowerPoint Viewer 2007. I’ve included copious notes on each slide which hopefully cover the gist of what I talked about when I was delivering it. There are also a handful of funky animations which is why I’ve left it in pptx and not exported to PDF or other format (sorry Open Office users).
I delivered my first presentation today, at the RittmanMead BI Forum.I was really nervous in the hours and minutes leading up to it, but once I got up there and started talking I actually quite enjoyed it. If you were in the audience, I’d love some feedback in the comments section below, particularly any “constructive criticism”. I obviously didn’t make too much of a mess of it, as I was awarded “best speaker” of the event, which was a great honour. Hopefully I’ll get the opportunity to present again soon, perhaps at an UKOUG event.
I’ve just returned from the RittmanMead 2010 BI Forum which this year was at the Seattle Hotel in Brighton Marina.
The event was limited to 50 attendees, and I think this was a good number. The event was explicitly pitched at a very technical expert level, and the audience very much represented this. Whereas at a larger conference you may find the odd manager wandering around pretending to be technical ;-) this event was most definitely not pitched at such types.
Troubleshooting EBS-BI integrated authentication can be a tiresome activity, so here’s a shortcut that might help. If you suspect the problem lies with EBS then you can leave OBIEE out of the equation.
What’s going on here? The username/password is definitely valid, proved by the sqlplus connection.
Configuring DAC in OBIA 7.9.5.1:
[sourcecode] What can I do for you?
1 - Enter repository connection information 2 - Test repository connection 3 - Enter email account information 4 - Send test email 5 - Save changes 6 - Exit
Please make your selection: 1
These are your connection type choices:
1 - MSSQL 2 - DB2 3 - Oracle (OCI8) 4 - Oracle (Thin) 5 - Keep current ( Oracle (Thin) )
This is a note-to-self really. When playing around with Oracle and something’s not working - RTFAL: Read The Flippin Alert Log!
After resizing a VM I was getting this problem: [sourcecode] [oracle@RNMVM01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 24 17:44:44 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount ORA-00845: MEMORY_TARGET not supported on this system SQL> [/sourcecode]
A faithful FireFox user for many users, I’ve been having a rather delightful rekindling of my old love for Opera recently. Back in the days, when I was a beardless bairn, I even paid for Opera I liked it so much. Then Firefox came along and Opera got dropped by the wayside like a teenage crush.
Well Opera 10.5 was released recently and I’m liking it. I miss my Firefox extensions too much to switch entirely, but damn, Opera is FAST!!
I’m doing my first ever conference presentation next month at the 2010 Rittman Mead BI Forum.
My presentation is called Performance Testing OBIEE, which is something I’ve spent a lot of time working on over the last few months. I think the challenge is going to be distilling it all into a session that’s not going to overwhelm everyone or bore them to death! Well, actually, the challenge is going to be the presenting. I can talk geek one-on-one, but talking to a whole bunch of people, not wittering but staying focussed, holding their attention….uh oh.
Spotted this when trawling through My Oracle Support. It’s pretty common knowledge anyway amongst people already familiar with hacking around with OBIEE, but worth recording for people coming along to it new.
Doc ID 1068266.1 states:
UDML is not supported in OBI 10g.
in 11g, XUDML (the Oracle BI Server XML API) will be fully supported and documented.
I’ve been playing around with SQL Tuning Sets, and was trying to clear up my mess.
To list all the tuning sets: [sourcecode language=“sql”] SET WRAP OFF SET LINE 140 COL NAME FOR A15 COL DESCRIPTION FOR A50 WRAPPED
select name,created,last_modified,statement_count,description from DBA_SQLSET [/sourcecode]
[sourcecode] NAME CREATED LAST_MODI STATEMENT_COUNT DESCRIPTION ————— ——— ——— ————— —————————————————————————————- sts_test_02 09-MAR-10 09-MAR-10 1 Test run 1 sts_test_01 12-FEB-10 12-FEB-10 1 an old STS test test test [/sourcecode]
OBIEE’s Systems Management functionality exposes performance counters and the application’s configuration options through Java MBeans and optionally a protocol called JMX.
It’s extremely useful, and is documented pretty widely :
In this article I’m going to discuss the use of JMX to access these counters remotely, and a possible security issue that’s present in the BI Management Pack manual. The BI Management Pack is an add-on to Oracle’s Enterprise Manager / Grid Control for managing OBIEE, see Mark Rittman’s excellent guide on Oracle’s website.
We hit a very interesting problem in our Production environment recently. We’d made no changes for a long time to the configuration, but all of a sudden users were on the phone complaining. They could login to BI from EBS but after logging in the next link they clicked took them to the OBIEE “You are not logged in” screen.
Our users login to EBS R12 and then using EBS authentication log in to OBIEE (10.1.3.4). Our OBIEE is deployed on OAS, load balanced across two servers by an F5 BIG-IP hardware load balancer.
A new document has been published by Oracle, discussing ways of improving performance for OBIA 7.9.6 and 7.9.6.1. Its primary focus is around improving ETL performance. There’s some very interesting content including hardware sizing recommendations, and I’d strongly recommend anyone working with OBIA reads it.
It’s called “Oracle Business Intelligence Applications Version 7.9.6 Performance Recommendations” and is available on My Oracle Support through Doc ID 870314.1
After it was ripped down last week, Chris Warticki’s blog is back online, albeit with the last posting redirecting visitors to a new location on Oracle Communities.
Maybe I’m getting too old for this s##t, but I’m yet to really get a handle on how Oracle want to interact with real people on the ground. Oracle Communities is a fairly new site that I’ve not explored so much because of no OBIEE area. My Oracle Support has feedback and comment sections, but in general usability stinks. A support blog is torn down and then reappears. Oracle Forums are popular as ever but the software blows and some forums (eg OBIEE) are withering under a very high noise to quality-content ratio. Oh, and Oracle Mix (“Bringing Oracle Customers, Employees, and Developers together”) too, which looked quite neat but I have no idea how that’s supposed to fit it the picture.
A sad little passing last week, of the Oracle Support Blog and related tweets by Chris Warticki.
Last week Chris posted this comment on twitter
followed by this terse blog posting:
Support Blog: No longer available
By chris.warticki on February 12, 2010 4:08 PM Please use My Oracle Support Communities instead
I stumbled across this blog posting recently, and am reposting the link here as I’ve seen no mention of it elsewhere. This surprised me as with Exadata (and most new technologies) any snippet of news or tech insight gets blogged and tweeted multiple times over.
Any insight into Exadata is interesting as unlike all the other Oracle software which can be downloaded and poked & prodded, this is a physical box so we rely on blog postings and marketing (with a BS filter) to understand more about it.
In the following list, which two mind-mapping programs are rated best?
Now look at the actual numbers, and answer again
Different answer?
I can’t be the only one in this frantic world whose eyes are drawn to the pictures instead of words and leap to conclusions. It’s only because I use FreeMind and was surprised it scored so low …. and then realised it hadn’t. Looks like the HTML rendering isn’t the same here (FF3.6) as when the web page author wrote it.
There is a LOT written about performance. And this post is now adding to it. Some of it’s excellent, some of it less so. But a lot of it starts from a point so far down the process that unless you know the first bit, you’re going to raring off and end up chasing your tail or p###ing in the wind…. (pardon my french). Without a well structured approach that you understand and always follow you’ll hit on solutions by luck only.
You get a call from your friendly DBA. He says the production database is up the spout, and it’s “that bee eye thingumy causing it”. What do you do now? All you’ve got to go on is a program name in the Oracle session tables of “nqsserver@MYSERVER (TNS V1-V3)” and the SQL the DBA sent you that if you’re lucky will look as presentable as this: 
The username against the SQL is the generic User ID that you had created for connections to the database from OBIEE.
