Cube Organized Materialized Views

Wednesday, March 26th, 2008 by Peter Scott

Yesterday, Mark mentioned a new Oracle white paper on Cube Organized Materialized Views - now that is a bit of a mouthful and shouts out to be made COMV or something equally short and saving of typing. I say that because I have recently submitted the final version (in time so as to be included […]

New White Paper on Cube Organized Materialized Views

Tuesday, March 25th, 2008 by Mark Rittman

I noticed on the Oracle OLAP blog the other day that a new white paper on Cube Organized Materialized Views has been uploaded to OTN. If you’ve followed Pete and my postings on this new feature in Oracle 11g the white paper goes into a bit more detail on how it works, and in our […]

OLAP and summary management

Saturday, March 8th, 2008 by Peter Scott

So, why is someone who normally writes about data warehouses going to talk about Oracle OLAP, and in particular, cube organized materialized views?
I could run out the argument that I work in a BI consultancy and none of us here at Rittman Mead are 100% aligned to a specific expertise area; for example I do […]

The Future of Oracle BI Beans

Saturday, February 23rd, 2008 by Mark Rittman

A question I’ve often been asked over the last year or so is “what’s happening with Oracle BI Beans?” For anyone not aware of what BI Beans is/are, it’s a J2EE component set that connects to Oracle OLAP via the Java OLAP API and was used as the building blocks for the OLAP version of […]

Oracle OLAP, partitions and time

Wednesday, February 20th, 2008 by Peter Scott

One of the reasons I am not writing too much on the blog at present is that I am busy working with a client just about to put a new (small) data warehouse into production. Coupled with the need to concentrate on submitting a white paper to Collaborate 08 by the weekend and I am […]

Almost started OLAP 11g…

Saturday, February 16th, 2008 by Peter Scott

The proposal deadline for the upcoming Collaborate 08 was shortly before I was to leave my old employer - it was already known that I would be leaving them to join Mark and Jon (and possibly, it was known before Rittman Mead Consulting existed!) so it came as no real surprise for Mark to ask […]

Some New Oracle OLAP and Essbase Blogs

Saturday, January 19th, 2008 by Mark Rittman

Just a quick posting on Saturday morning to mention some new Oracle OLAP and Essbase blogs that I’ve come across.
First up is an Oracle OLAP blog by some of the most well-known people behind the product. Kevin Lancaster (well known to us at the UK Oracle User Group), Keith Laker (ditto), Jameson White (the man […]

More on Oracle OLAP 11g and Query Rewrite

Saturday, December 15th, 2007 by Mark Rittman

Over the past few days I’ve been taking a closer look at how query rewrite works with the new 11g release of Oracle OLAP. As a quick recap, in Oracle 11g you can now use OLAP analytic workspaces as summaries within your data warehouse, with Oracle now able to register OLAP dimensions and cubes as […]

Integrating Oracle OLAP and ApEx

Tuesday, December 11th, 2007 by Mark Rittman

A demo I’ve seen at several Oracle events over the past year is one where ApEx (Application Express) is linked in with Oracle OLAP. The idea is that the charting and reporting capability of ApEx is used against the SQL views over an Analytic Workspace, giving you the ease of development of ApEx combined with […]

A First Look at Oracle OLAP 11g

Saturday, November 17th, 2007 by Mark Rittman

Now I’m on the flight over to London back from Open World, I’ve got a few hours spare to take a proper look at the 11g release of Oracle OLAP. In particular I’m trying to find out whether it runs ok without any show-stopper bugs, whether there are any new features in Analytic Workspace Manager, […]