Rittman Mead - Delivered Intelligence

I gave a BI keynote (pdf copy of slides) at a couple of events last week (the Business Intelligence, Warehousing and Analytics Summit in Reston, VA and the OUG Scotland Conference & Exhibition, Glasgow), and as it’s been picked up on the Eye on Oracle blog site, I thought that it’s worth giving a bit […]

Whilst I was over at Collaborate’07 last month, one of the biggest bits of product news that I heard about, but couldn’t mention fully at the time, was details of the new 11g release of Oracle OLAP. Chris Claterbos from Vlamis Software Solutions was given permission by Oracle OLAP product management to put some slides […]

Just a quick posting as I’m about to get my flight back to the UK (via San Francisco, unfortunately, so it’ll be a long journey). Yesterday I went to talks on SOA and RAC, and went along to Cary Millsap’s talk on why you often end up tuning the wrong thing when trying to optimize […]

I mentioned the other day that a new version of AWM was now available following the release of the 10.2.0.3 patch for Oracle Database 10g. One of the new features that this latest version of AWM comes with is the Sparsity Advisor.
I covered the PL/SQL Sparsity Advisor earlier in the year, but at the time […]

Following on from the 10.2.0.3 patch release for Oracle Database 10g, Anthony Waite has just informed us that the 10.2.0.3 release of Analytic Workspace Manager and the Global Sample Schema are now available for download on OTN.
According to Anthony, the new features of this release include:
“* Sparsity Advisor determines which dimensions are sparse, which storage […]

I’m sitting now in the Speaker Ready-room down in the Moscone South mezzanine, in between sessions on Oracle Database 11g and the BI Suite Enteprise Edition & Standard Edition presentations later this afternoon. The morning started off with the Chuck Rozwat keynote on Oracle’s database technology, a run through of the new 10g products launched […]

I noticed the other day that a number of new BI-related papers and downloads have gone up recently on OTN.
“New Features and Performance Enhancements in Oracle OLAP 10g Release 2″ goes into a bit more detail on new 10gR2 features such as measure compression, partitioning and new SQL access enhancements, and will be useful reading […]

Right, I’ve been meaning to post this to the blog for a couple of weeks now but I keep getting sidetracked. If you followed the debate around my Incremental Load Improvements in Oracle OLAP 10gR2 posting a couple of months ago you’ll be interested in a follow-up Scott Powell did on the […]

In addition to the conventional
Select D1,D2,SUM(M1) from base group by D1,D2
type of summary Oracle offers two other approaches: Oracle OLAP cubes and the various extensions to GROUP BY. Oracle OLAP has it roots in the Oracle Express technology - that is the the stand alone OLAP database and not any more recent additions to […]

In one of last week’s postings I looked at how relational data objects are defined using Oracle Warehouse Builder 10gR2. In this posting, I’ll look at how OLAP objects are defined and populated.
To define OLAP objects, you don’t need to have installed and licensed the OLAP Option to the Enterprise Edition of the database. Without […]