OBIEE, OBI Apps, ODI, Informatica, Essbase, BI Publisher...you name it. The OBI suite entails them all and more.
I will talk mainly about its technical aspects, interesting findings and noteworthy solutions, but will definitely throw in some random weirdness.

Tuesday, April 24, 2012

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?