A quick post to advertise
Oracle's BI Tech Demos youtube channel !
Very good content and good information, even if a lot isn't available to the public and/or only on NDA basis. Extremely valuable peek into the future though so you can see what's upcoming.
OBIEE 11.1.1.6.6 (aka 11.1.1.6.0 BP6) is out and until MOS hosts a proper tracking note, here is the list of all patches making up this patch set with direct links.
Patch 15844023 Patch 11.1.1.6.6 (1 of 7) Oracle Business Intelligence Installer
Patch 15844066 Patch 11.1.1.6.6 (2 of 7) Oracle Real Time Decisions
Patch 14800665 Patch 11.1.1.6.6 (3 of 7) Oracle Business Intelligence Publisher
Patch 15843961 Patch 11.1.1.6.6 (4 of 7) Oracle Business
(more...)
While I was off, Oracle released OBIEE 11.1.1.6.5 which is another bugfixing patch set which doesn't bring in new functionality but irons out quite a few quirks.
Here you can find the main MOS article detailling the patches making up this patch set as all bugs fixed in it.
By the way...make sure you don't forget
JDEV patch 13952743.
Cheers!
The long awaited
"Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial" (Packt publishing) by
Christian Screen,
Haroun Khan and
Adrian Ward was finally released two weeks ago (
Amazon) and I got the hard copy delivered today (haven't tried the Kindle version yet...).
As I have been hanging around Oracle BI and its various ancestors since quite a while I was eagerly looking forward to this one - as well as
Marks forthcoming book - for several reasons:
First of all it always boggled my mind as to just how someone would go about packing the
(more...)
After an OBIEE 11.1.1.6 in-place upgrade I accidentally found weird warnings in the startup log of WebLogic since the upgrade. "By accident" since the server started nicely and was available without loss of functionality or performance, so I never checked in detail what happens during startup.
The WLSStart.log contained the following nice list:
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table "discussion:Response" has no key column. It will not be collected.}
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table "oracle_bi_instance:essbaseServerMetrics" has no key column.
(more...)
Just something of note. I stumble upon this from time to time and really don't appreciate it:
Agents being called by other Agents (i.e. agent chaining) will NOT write any execution information into S_NQ_JOB or S_NQ_INSTANCE.
So no LAST_RUNTIME_TS in S_NQ_JOB nor new line in S_NQ_INSTANCE.
Really not useful when using these tables as sources in the RPD to check and schedule execution of Agents! E.g. when did which agent run last with which result and should I run it again?
Cheers!
It has been 19 months since the GA of OBIEE 11g and its third incarnation (11.1.1.6) is celebrating its one-month-birthday today. Time to make a point on the support situation for all OBIEE 10g implementations out there:
The last 10gR3 versions (10.1.3.4.x) will reach the end of the Permier Support lifecycle in 4 months, July 2012.
The full documentation for lifetime support of Fusion Middleware products can be found here, on the Oracle website (last updated February 2012). The screenshot above can be found on page 13 of the pdf.
It's time again. This years BI forum (#biforum) is open for registration!
All information on topics, speakers and locations can be found here:
http://www.rittmanmead.com/biforum2012/Direct registration links for Brighton and Atlanta respectively are here:
Booking form for UK BI Forum Event (Brighton, May 8th – 11th 2012)Booking form for US BI Forum Event (Atlanta GA, May 15th – 18th 2012)Thanks to Mark and his crew for continuing to host this awesome event!
When hooking up OBIEE 11g to an LDAP, make sure to check some factors on the LDAP side of things as well. Not all errors have to come from your configuration in WLS:
- LDAP users intended to replace "OracleSystemUser", "weblogic" and "BISystemUser MUST" all reside in the same base DN that's used to search for users in the LDAP config
- They also MUST all be of the same objectClass as the one referenced in the LDAP config
- Creating "technical users" to distinguish them from "human users" and putting them in different branches and / or storing them as different object (more...)
Yes, I have quite a backlog of topics I should blog and thanks to Robin for pointing it out.
A quick reminder about using the right wlst.sh.
In a normal OBIEE installation, you will find multiple wlst.sh in the MIDDLEWARE_HOME:
./wlserver_10.3/common/bin/wlst.sh
./Oracle_BI1/common/bin/wlst.sh
./oracle_common/common/bin/wlst.sh
Make sure to always start your wlst scripts from
./oracle_common/common/bin/wlst.sh
in order to prevent erroneous behaviour. Running them from a different location will yield interesting errors like the one below - taken from a migrateSecurityStore example:
TypeError: cannot concatenate 'str' and 'NoneType' objects
Cheers!
OBIEE 11.1.1.6 became available yesterday evening (CET) first on edelivery and in the meantime on OTN as well. Here's a link library of the most important and interesting sources.
Downloads:OTNedeliveryOverview and explanatory blog posts:PeakIndicators
"New Features with OBIEE 11.1.1.6"RittmanMead
"OBIEE 11.1.1.6 Now Available for Download – Release Highlights""OBIEE 11.1.1.6 : MDS XML Repositories, and Integration with Source Control"Michael Verzijl
"OBIEE 11.1.1.6 Released – Short overview"Addidici
"OBIEE 11g R1.6 New Admin Feature"Alex Hansal
"OBIEE 11.1. (more...)
I recently deployed a new RPD to one of my BI servers and after restarting the coreapplication, wasn't able to log on anymore - the login process hung at "Singing in..." indefinitely.
After some investigation, I found out what had happened:
1.) The new RPD used connections to a datasource situated on a different database (other than the primary DWH) which were utilised in new initialization blocks which fired upon login (no "deferred execution").
2.) The TNSNAMES on the BI server machine had contained all necessary connectivity information until the night before, but had been reset to
(more...)
Hello everybody, this blog has been dormant for quite a while now. Today, my buddy
Robin tweeted on a blog post which was imply too true and too good not to share. This prompted me to rethink my decision to abandon blogging and get this blog going again. So without much further ado, here's the promised link:
http://jamesmorle.wordpress.com/2011/09/16/right-practice/ James is spot-on with this one. Adding to his line "Best Practices are being used as an alternative to rational thought." I would like to point out one more thing which I see happening more and more often: Best
(more...)
According to
Daan Bakboord over here, Robin and me reached ultimate twitter geekness when I watched Daan tweeting, took a pic of him and tweeted it and Robin took a pic of me taking a pic of Daan tweeting...



Well agreed it was kinda geeky in a web 2.0orhea kind of way. Still, I vote for this pic as the winner of the generic geek award, category t-shirt:

So after this, here's all the pics I took:
Hi all,
well what can I say...the
BI forum at the Brighton Marina was a blast. Almost the whole european blogger community was there and we had a real good time and extremely good discussions. Plus as of Friday we even had goo weather!

Last things first, at the end we voted for the best speaker of the event and
Robin Moffatt won this year. Especially cool for him since we popped his speaker-cherry at this event ;-) So congrats Robin.
The first day of the event was a masterclass on OBIEE with Kurt Wolff. I'm sure you all
(more...)
Thanks to
rnm1978 for alerting me to the availability of this rather juicy document on MOS:
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=870314.1And the really cool part?
Oracle positions Exadata solution as fast and efficient hardware for addressing I/O bottlenecks in large volume environments. The internal benchmarks for running Oracle BI Applications on Exadata will be published soon.
Sweeeet!