- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Designing cubes. OWB vs AWM
There are two UI tools provided by Oracle to create cubes based on cube organized MVs.
AWM allows to create cubes in analytic workspace in particular schema and then deploy them.
"Enable Materialized View Refresh pf the Cube" should be checked to generate MVs.
On the other hand OWB also allows to do the same.
But in this case there is no need to create Analytic workspace and all the metadata will be stored in owbsys schema.
"ROLAP: with Cube MVs" should be checked to generate MVs.
Both approaches allow export/import metadata and promote changes to production. As well as automation of this process.
So the question is which tool is preferable to use for designing cubes and why?