Oracle BI Tech Demos youtube channel

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 Patch Released

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

OBIEE 11.1.1.6.5

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!

11.1.1.6.4 patch has been released for OBIEE

Patch 11.1.1.6.4 is here and can be downloaded from MOS.

Once more it's a 7-pack patch and here are the patch numbers and direct links:

Patch 14538078: PATCH 11.1.1.6.4 (1 OF 7) ORACLE BUSINESS INTELLIGENCE INSTALLER
Patch 14538128: PATCH 11.1.1.6.4 (2 OF 7) ORACLE REAL TIME DECISIONS
Patch 14285344: Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher
Patch 14538164: PATCH 11.1.1.6.4 ( 4 OF 7) ORACLE BUSINESS INTELLIGENCE ADF COMPONENTS
Patch 14415773: Patch 11.1.1.6.4 (5 (more...)

D3.js calendar configuration in OBIEE 11g

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial


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

WLS Startup Warnings after OBIEE 11.1.1.6 upgrade

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

OBIEE Agent Chaining does not update Scheduler tables

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!

OBIEE 11g in-place upgrade issue with configuration lock

In-place upgrade within OBIEE 11 versions (from .3 to .5 o r .6 or from .5 to .6) can be a whole lot quicker than out-of-place ones but are also more interesting in terms of potential issues arising. After two uneventful in-place upgrades from 11.1.1.5 to 11.1.1.6 I had a more challenging third upgrade with some unexpected errors.

If you look at the official upgrade guide, all went fine up to item 6: "Upgrading system components". Executing upgradenonj2eeapp.sh, however, threw an error while re-deploying:
./upgradenonj2eeapp.sh -oracleInstance /bishiphome/Middleware/instances/myinstance/ -adminHost localhost (more...)

Reminder: OBIEE 10g premier suppport ending soon

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.

RittmanMead BI Forum 2012 open for registration

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!

OBIEE 11g LDAP integration gotchas

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:

  1. 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
  2. They also MUST all be of the same objectClass as the one referenced in the LDAP config
  3. Creating "technical users" to distinguish them from "human users" and putting them in different branches and / or storing them as different object (more...)

List of Bugs Fixed – OBIEE 11.1.1.6 (MOS)

The official list of bugfixes included in 11.1.1.6 is out:

Maintenance Release Guide (List of Bugs Fixed) for Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6.0 [ID 1412748.1]

wlst.sh – where to execute it from

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!

Updated: OBIEE 11.1.1.6 Link Library

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:
OTN
edelivery

Overview 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...)

OBIEE 11g: Login hangs with "Signing In"

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

Too true to miss

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

BI Forum – consolidated geekness awards

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:

BI Brighton Forum

BI Forum Brighton 2010

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

OBIA 7.9.6.1 Performance Recommendations

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

And 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!