Rittman Mead - Delivered Intelligence

Oracle in talks to buy Siebel
: "Oracle is in talks to buy Siebel Systems for a price tag that could reach $5 Billion The Daily Deal reports. The high-level discussions between the two companies have been confirmed by insiders and industry analysts, but are preliminary and could still break down, according to the news […]

I’ve been playing around with one of the OWB "Paris" betas, and one of the things
that most struck me about this version of OWB compared to previous ones is the
degree to which it utilizes the

OLAP Option. Current and  previous versions of OWB primarily created
relational data warehouses, with the addition of CREATE DIMENSION statements to
help with […]

One
or two of you might be wondering how I’ve managed to find the time to write so
many articles recently, and the answer to this is down to something you
might have read about
a few weeks ago where our local train service is trialling wireless
broadband internet access on the Brighton to London train each morning. I’ve
been travelling […]

To schedule an OWB mapping or process flow to run at a set time, and
optionally to run again after a set interval, without having to deploy it to OEM:
First, log on as the Runtime Repository owner, and run the following script
to create a function called RUN_OWB_JOB. This is a slightly modified version of
the RUN_MY_OWB_STUFF.SQL script […]

If you’re looking to tune an SQL statement or a batch job, a common way to
find out what happened during the execution of the SQL is to run an extended SQL
trace and examine the wait events. But what happens if you are using parallel execution, and all your trace
file contains is the parallel execution wait […]

Neil Raden, who’s article on
Model-Driven Approaches
For BI Projects I linked to last year, dropped me a line to tell me about
some new real-time ETL articles he’d written:

"Mark,
I’ve written some articles and white papers about real-time data
warehousing:

http://ww.hiredbrains.com/knowout.html
…but I think the really interesting part of it is not data warehousing,
per se, but abstraction and real-time analytics. Abstraction […]

A number of clients I’ve worked with recently have been looking to implement OracleBI Discoverer 10.1.2 for OLAP as their general ad-hoc query tool. Whether running against relational OLAP data or data in analytic workspace, Discoverer for OLAP comes with a slick new interface, an OLAP-aware query builder and works against a logical dimensional model […]

A number of clients I’ve worked with recently have been looking to implement
OracleBI Discoverer 10.1.2 for OLAP as their general ad-hoc query tool. Whether
running against relational OLAP data or data in analytic workspace, Discoverer
for OLAP comes with a slick new interface, an OLAP-aware query builder and works
against a logical dimensional model that mirrors the way […]

Oracle Rebrands Middleware As Fusion :
"Oracle is slapping a new "Fusion" moniker on its array of middleware and
development tools. "Oracle Fusion Middleware" to be formally announced Monday,
will be the umbrella brand for some 32 products including Oracle’s J2EE server,
portal, data integration, application development, business intelligence,
identity management, and collaboration offerings, said Rick Schultz, vice
president of product […]

So, you have got those MV in place and now need to keep them up to date, well there are three options: do-it-yourself, Complete refresh and ‘Fast‘ refresh. To me, fast is not the right name, as under the covers all of the rows affected by data change are updated, this can be quick or […]