If anyone's interested, i've written up a short summary of some of the
new OLAP features in Oracle 10g.

'The SQL Model Clause' : http://www.rittman.net/2003/09/15.html
'10g OLAP New Features / Excel Add-in' :
http://www.rittman.net/2003/09/10.html
'Discoverer Support for MOLAP Data' :
http://www.rittman.net/2003/09/09.html

The articles also link through to the relevant white papers recently
released at Oracleworld.

regards

Mark Rittman
http://www.rittman.net

Hi Hans,

To answer your questions;

None of the 10g server software (database, app server) is publicly
available yet. Beta copies of the database have been made available to
Oracle Partners and ISVs, for Linux, Solaris and HP-UX, but there is
no 'public beta' planned as far as I know. I don't know about 10g AS;
but the lack of any mention of it on the newsgroups suggests it's not
at this stage yet (although of course it could just turn out to be iAS
9.0.4 rebadged, which would suggest that the first release of 10gAS
will not contain any significantly different versions of Disco,
Reports etc - but we'll just have to wait and see). According to
Oracle, the first full release of 10g Database will be later this
year, although I would expect this to be a Unix-only release at this
stage.

There's two parts to this here; the server side of things, and the
developer tools. For the server side, you need 9i Enterprise Edition
Database (for the ROLAP functionality, materialized views and so on)
and 9iAS Enterprise Edition App Server (for Portal, OID, Discoverer).
The database version you start with should be 9.0.2.0.1, patch it up
to 9.0.2.0.4.1, and install the analytic workspace manager. The app
server version should be 9.0.2, and patch it up to 9.0.3.

You then need 9iDS to give you Discoverer Administrator; you'll
probably need to patch this to match the EUL version that you've
reached when patching 9iAS. In addition, download separately OWB 9.2
and use this instead of the OWB version that comes with 9iDS.

If you install this lot, you'll get;

- 9i Database, with the 9.0.2.0.4.1 patchset, and Analytic Workspace
Manager, to migrate relational OLAP cubes to analytic workspaces, and
automatically create the SQL Views and Disco Business Areas.

- 9iAS, with Disco patched up to the correct version

- 9iDS, with Disco Admin patched up as above

- OWB9.2, which can create ROLAP cubes, or MOLAP cubes now that you've
patched the database up to 9.0.2.0.4.1

hope this helps

Mark Rittman

http://www.rittman.net

Hans, One other thing -

With regard to Discoverer 10g working against Oracle 9i - it's too
early to tell. The product has only been recently mentioned by Oracle
(http://www.rittman.net/2003/09/09.html) and they're careful not to
call it 'Discoverer 10g' or give a release date. We'll have to wait
and see what gets announced over the next few months.

regards

Mark