OWB10gR2 Add-on Experts Available
December 12th, 2006 by Mark Rittman
I just noticed on the OTN OWB Exchange page that four add-on “Experts” are available for Warehouse Builder 10gR2.
- the Create Dimension Expert, that allows you to create a ROLAP or MOLAP dimension from an existing table.
- the AW/XML Import Expert, that allows you to import AWM dimension, cube and measure templates into OWB.
- the OLAP Accelerator Expert, for adding forecasting and allocation for (presumably MOLAP) cubes, and
- the OSA Migration Expert, for migrating Oracle Sales Analyzer cubes to Oracle OLAP.
If you were at the last UKOUG BIRT SIG, the Create Dimension and AW/XML experts were the ones Andy Welsh demonstrated in his talks, and we’ve been discussing the AW/XML import feature at the recent BI Masterclasses I’ve been running. I’ve been waiting for these, I’ll have to download them shortly and take a look. Nice one.
December 12th, 2006 at 9:24 pm
Mark, I have been working lately a lot on Siebel Analytics. As you know with Siebel Analytics we can define our measures ,dimesnions etc the entire Business layer. I have been wondering how would OWB fall into the scheme of things if we already have Siebel Analytics installed - besides using it for ETL purposes.
December 14th, 2006 at 7:25 am
Mark, according to the this link , Oracle has beaten you in terms of blogging.
December 16th, 2006 at 1:27 pm
Vidya - OWB doesn’t really have any links into Siebel Analytics / OBI EE, except that of course it provides the data that OBI EE reports against. It’s limitations are that it only loads Oracle databases, whereas OBI EE is really designed for any database platform, not Oracle, and of course at the moment it can’t translate OWB dimensions, cubes etc into their SA equivalents.
I think that the new Sunopsis products will be the ones that will be enhanced to work with OBI EE, although as Data Conductor isn’t really a data modelling tool, and there are no OLAP modelling features within it, it looks unlikely that even with this tool, you’ll be able to define your cubes and dims within Data Conductor and then export them to OBI EE.
What Oracle really need is a universal BI architect’s workbench, where you can model your data, export the metadata to Discoverer or OBI EE, load both Oracle and non-Oracle databases - which is very much like what Microsoft are doing with Visual Studio and it’s BI plugins. It’ll be interesting to see how Oracle’s ETL and BI management product lines develop over the next few years.
regards
Mark
December 16th, 2006 at 1:28 pm
Rupert - thanks for the link, it’s a nice complement of sorts
cheers
Mark
December 18th, 2006 at 3:01 am
Mark - Thanks a lot for taking the time to explain details on OWB.
February 1st, 2007 at 7:05 pm
Hi Mark
OWB has a bad name don’t you think
…..it would be sensible for OWB to deploy current Business Definitions which get deploy to Disco currently to OBI EE.
Regarding the experts, there are a number of new experts including;
- experts for generating components for consuming/producing XML using XML SQL
- expert for integrating data with the Balanced Scorecard interface tables
- multi configuration experts
Cheers
David