There’s a thread going on
There's a thread going on at OTN about the Analytic Workspace Support in OWB. The original poster asks whether OWB can actually build and populate an AW, and when the required 9.2.0.3 database patch is coming out. Shauna O'Boyle has responded and there's some useful pointers and updates which I'm reproducing.
- The Oracle 9i 9.2.0.3 patch, which the Analytic Workspace Manager and OWB need to be able to build and populate Analytic Workspaces, is now due July 2003, although the specific date hasn't been confirmed.
- If you want to run BI Beans using a cube built using OWB, at present it has to be a ROLAP cube, at least until the 9.2.0.3 patch comes out.
- To deploy a ROLAP cube, you deploy the facts and dimensions as normal using OWB 9.0.4., then use the metadata bridge to create the CWM1 metadata.
- When the 9.2.0.3 patch comes out, this bridge will then also be able to create the metadata for a MOLAP cube in the Analytic Workspace.
- If you are using the metadata bridge, you should apply the OWB 9.0.4.10 patch which has a number of improvements and bug fixes that will help deploying to OLAP.
In a separate thread, it appears that the next version of OWB will be OWB 9.2. It's due to be released in mid-July 2003. OWB 9.0.4 was quite a change from previous versions and i've had mixed feedback from colleagues about some of the new deployment and debugging features, although it must be said that it's good to get the SAP integrator back. It'll be interesting to see what OWB 9.2 delivers.