Major Enhancements to
Oracle 10g Analytic Workspace Manager Announced
August 31, 2004
Oracle's Data Warehouse Guru, Anthony Waite just published this
announcement on OTN:
The 10.1.0.3 patchset for Oracle 10g is now available on MOSC,
patch number 3761843. It's a 448MB download and is available now for
MS Windows, Intel Linux, and a few of the 64-bit Unices. There are
two corresponding OLAP patches; OLAP 10.1.0.3.0A patch (patch number
3769360) which Oracle
recommend should be applied to all existing 10.1.0.3 installations -
both client and server - and a 10.1.0.3B patch, due out at the end
of September, along with version two of the Analytic Workspace
The 10.1.0.3A patch introduces a couple of items of new
functionality to Oracle OLAP:
a.. The existing 10.1.0.1 AWM is upgraded to AWM 10.1.0.3.0A, with
users no longer being required to manually enable the analytic
workspace for query by the OLAP API. Dynamic enablement
automatically creates compatible SQL views over the analytic
workspace even if you change the logical model.
b. AWM 10.1.0.3A uses the new AWXML feature for query access, with
the forthcoming AWM2 switching over completely to AWXML for
defining and loading AW objects.
Although the 10.1.0.3A patch looks interesting, the major change for
10g OLAP is coming with the 10.1.0.3B patch, which introduces all
the features outlined in Mike Ault's 10g OLAP article and Anthony
Waites comments earlier in the year on the OTN OLAP Forum. Oracle
OLAP 10.1.0.3B, through it's use
of AWXML and AWM2, will allow analytic workspaces to be created
directly from Oracle relational tables, or flat files using the
external tables feature, without the intermediate step of creating a
CWM1-compliant ROLAP cube. In addition, AWM2 will support new
features that have been introduced with 10g OLAP, including
multi-writer support, partitioning and compression, and will have a
big emphasis on users who are 'data dabblers', making it easier to
create and populate analytic workspaces.
The 10.1.0.3B patch, and AWM2, are scheduled to be made available
around 30th September.
As all of this will make the current 10g OLAP documentation out of
date, the OLAP DML Guide is being be re-edited and should be
available within a week.