Oracle Read - Oracle Blogs Aggregator

Here we will look at building cube organized materialized views for a relational fact table. The illustration uses the Oracle OLAP 11g Sample Schema and rather than the cube organized materialized views being created via the script in the demo, they will be designed and generated from OWB. The cubes and dimensions designed in OWB can serve multiple purposes;

physical data warehouse tables may be generated
dimensionally aware ETL operators for maintaining data
cube organized materialized views generated for summary management and performance
derive the OBIEE layers - a great metadata integration scenario.

OWB 11gR2 supports the design of 11g form

…click on the title to read the full article…