tag:blogger.com,1999:blog-3820031471524503731.post8737603170125527781..comments2022-03-30T12:21:24.920-07:00Comments on Oracle OLAP: Best Practice Tips : SQL Access to Oracle DB Multidimensional AW Cubes (#1)Brian Macdonaldhttp://www.blogger.com/profile/18408740222558531436noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3820031471524503731.post-16905687042328197112009-07-13T11:13:45.856-07:002009-07-13T11:13:45.856-07:00Hi Richard
I believe that this will be a feature o...Hi Richard<br />I believe that this will be a feature of the upcoming OWB "Database ETL" release which will ship with Database 11gR2.<br />Until then, you are right, OWB only deployes to 10g style AWs.<br />I would therefore recommend using AWM to do your cube designe etc, and have it generate PL/SQL scripts for all the different Maintenance tasks you may want to do, and then have OWB use these in its ETL work flows. Not pretty, but it works fine (not just for OWB, but for other ETL tools too).<br />KevinKevin Lancasterhttps://www.blogger.com/profile/06742628997065141834noreply@blogger.comtag:blogger.com,1999:blog-3820031471524503731.post-49421795665677523062009-03-09T09:57:00.000-07:002009-03-09T09:57:00.000-07:00Im using the latest version of OWB 11 (11.1.0.7.0)...Im using the latest version of OWB 11 (11.1.0.7.0) against an 11g DB. <BR/><BR/>Can OWB11 target 11g OLAP yet? OWB seems to deploy dimensions and cubes to a 10g AW.<BR/><BR/>I wish to use OWB to generate the MOLAP objects and then tweak the cubes to use query rewrite.<BR/><BR/>Regards<BR/>RichardAnonymousnoreply@blogger.com