Plans (query and work)

Friday, January 13th, 2006 by Peter Scott

One of our customers has a possible problem with a data discrepancy. Two queries that should return the same results don’t. We should get copies of the queries early next week so we can tear the two apart. We need to analyse whether the results should be the same. And if they should be […]

Looking for a Good Discoverer, Reports and Portal Consultant

Thursday, January 12th, 2006 by Mark Rittman

Are you a bit of an expert in Oracle Discoverer, Reports and possibly Portal,
perhaps work for a company but looking to move in to consultancy? If so, I’m
looking for someone like this to work with me on my team at
SolStonePlus.
We’ve currently got an opening for someone with good Discoverer, Reports and
ideally Portal experience, either standalone […]

New Global AW Schema Available on OTN

Wednesday, January 11th, 2006 by Mark Rittman

Anthony Waite, on the OTN OLAP Forum:
“The Oracle OLAP Application Developer’s Guide 10.2 uses a specific version of the GLOBAL schema for some of its examples. This version, global_doc.zip, has been updated and posted to OTN. In the previous version, Window users may have run into a problem installing the Second Global […]

New Global AW Schema Available on OTN

Wednesday, January 11th, 2006 by Mark Rittman

Anthony Waite, on the OTN OLAP Forum:

"The Oracle OLAP Application Developer’s Guide 10.2 uses a specific
version of the GLOBAL schema for some of its examples. This version,
global_doc.zip, has been updated and posted to OTN. In the previous version,
Window users may have run into a problem installing the Second Global Schema
for Documentation. It was discovered that […]

Michael Jennings : “Not Your Father’s ODS”

Wednesday, January 11th, 2006 by Mark Rittman

Not Your Father’s ODS : "In this article, I’ll propose a solution that
builds on a key investment already in place at many organizations: the
operational data store (ODS). Experience with ODS implementations is growing at
a propitious time — a time when IT desperately needs to think outside the box
about where to take its enterprise information strategy. […]

A view of BI (part 3)

Tuesday, January 10th, 2006 by Peter Scott

At the end of last year I posted the first two parts of a piece on my view of BI. Spurred on by Nicholas Goodman’s post on the Pentaho workshop, I thought that I should get around to finishing part 3 of my view of BI.
The ‘swan’ I mentioned in part two of this series […]

Average for a week

Sunday, January 8th, 2006 by Peter Scott

In most data warehouses there is some form of aggregation going on, sometimes in the presentation of database summary tables, sometimes in the query tool. Often this aggregation is additive over time: how many times did this IP address connect to that web page in a month, what is the total value of baked bean […]

VMWare Player Prebuilt Virtual Machines

Friday, January 6th, 2006 by Mark Rittman

Spotted
via

Duncan Lamb’s site: the
"Community Virtual
Machines" page on the VMWare website, where you can download prebuilt
virtual machines for use with VMWare and the new (free) VMWare Player,
including:

Debian Sarge 3.1
Fedora Core 4
Fedora Core 5 Test 1
FreeBSD 6.0
KDE on SuSE OSS 10.0
Kubuntu (KDE on
Ubuntu)

Of course there’s the standard "supported" VMs as well, including ones for
Ubuntu,
SuSE 10,
Oracle on Red […]

Oracle Reporting Tools Forum Up and Running

Thursday, January 5th, 2006 by Mark Rittman

The Blog Forum is up and running now over at
http://www.rittman.net/forum.
I set this up for two reasons. First is that I get a number of technical
questions through directly, and I often don’t have the time (or the answer to
hand) to be able to help out straight away. If you post to the forum instead
I’ll try and […]

RSS Feeds Now Validating

Wednesday, January 4th, 2006 by Mark Rittman

Someone dropped me a line earlier this evening to say that my RSS and Atom
feeds weren’t validating correctly. I’m not sure if this is following my site
upgrade or if they ever validated before, it looks like from
this
article Moveable Type has a history of generating invalid RSS feeds. Luckily
the same article has feed templates that do […]