Ralph Kimball On The 38 Subsystems Of ETL

Monday, January 31st, 2005 by Mark Rittman

Ralph Kimball, "The 38 Subsystems Of ETL" : "The extract-transform-load (ETL)
system, or more informally, the "back room," is often estimated to consume 70
percent of the time and effort of building a data warehouse. But there hasn’t
been enough careful thinking about just why the ETL system is so complex and
resource intensive. Everyone understands the three letters: […]

News Update, and A First Look At OWB “Paris”

Monday, January 31st, 2005 by Mark Rittman

I’m conscious that I haven’t updated the weblog much over the last few weeks
so I thought it worth posting a note of explanation. Funnily enough I have
actually still been working away on articles and presentations over the last
couple of weeks, but they’re all for other sites or publications and
consequently won’t be available for a couple […]

Can Discoverer “Drake” Replace Discoverer Desktop?

Monday, January 24th, 2005 by Mark Rittman

I was working with one of our customers last week who was looking at implementing the new OracleBI Discoverer 10g, otherwise known as “Drake”. The customer already used Oracle Discoverer Desktop 3i and had previously looked at upgrading to Oracle Application Server 9i Discoverer Plus, but had chosen not to upgrade […]

Can Discoverer “Drake” Replace Discoverer Desktop?

Monday, January 24th, 2005 by Mark Rittman

I was working with one of our customers last week who was looking at
implementing the new OracleBI Discoverer 10g, otherwise known as "Drake". The
customer already used Oracle Discoverer Desktop 3i and had previously looked at
upgrading to Oracle Application Server 9i Discoverer Plus, but had chosen not to
upgrade to this version due to a number of […]

SolStonePlus Is Hiring

Friday, January 21st, 2005 by Mark Rittman

If you’ve got experience with Oracle’s BI&W tools and you’re looking to work
on some of the best and most interesting projects in the UK and Ireland, you
might be interested to know that
SolStonePlus is now hiring.
Right now there are openings for people with Oracle Warehouse Builder,
Oracle Discoverer and Oracle Application Server skills. Applicants must be
prepared […]

New Oracle Business Intelligence 10g Training Resources

Sunday, January 16th, 2005 by Mark Rittman

If you’re interested in evaluating
Oracle Business
Intelligence 10g, one thing you might have missed around the time of the
launch was the release of a number of new "Oracle By Example" training courses
on these new products.
Available over
at OTN, they cover the following topics:

Using the Oracle BI Spreadsheet Add-in

Viewing Sales History Information Using OracleBI Discoverer Viewer

Analyzing Sales History […]

Analytic Functions By Example

Saturday, January 15th, 2005 by Mark Rittman

Analytic
functions by Example : "This article provides a clear, thorough concept
of analytic functions and its various options by a series of simple yet concept
building examples. The article is intended for SQL coders, who for might be not
be using analytic functions due to unfamiliarity with its cryptic syntax or
uncertainty about its logic of operation. Often I […]

Migrating Express Server Databases To 10g And Discoverer “Drake”

Thursday, January 13th, 2005 by Mark Rittman

A task I set myself over the Christmas break was to put together an Oracle
10g OLAP demo for one of our customers. Like many of the organisations we’ve
worked with over the years, the customer had a business intelligence solution
built on Oracle Express Server technology, and they were interested in what
their system might look like if […]

New Oracle Magazine Article On Business Intelligence

Thursday, January 13th, 2005 by Mark Rittman

Oracle
Magazine are running a special feature this month on business
intelligence and data warehousing. "Eye
On Information : Business intelligence: It’s not
just for big enterprises any more. Companies of all sizes and shapes are
implementing BI systems or BI-enabling their applications to learn more about
their business, cut costs, and improve efficiencies.". An interesting
article that looks at some of […]

News On The Forthcoming UKOUG BIRT SIG

Wednesday, January 12th, 2005 by Mark Rittman

Things are pretty busy at the moment, with a number of projects about to kick
off that use OWB and the new Business Intelligence 10g products. At the current
time I’m spending most nights away from home and I’ve got a number of personal
projects on the go, including writing an article for OTN on dashboards using
Discoverer "Drake" […]