Creating Materialized Views for Dimensions

You can use OLAP Summary Advisor or the DBMS_ODM PL/SQL package to create dimension materialized views. When you use OLAP Summary Advisor, the dimension materialized views are automatically created along with the fact materialized views for a CWM cube. When you use the DBMS_ODM package, you must call the CREATEDIMMV_GS procedure to create dimension materialized views.

The syntax of the CREATE MATERIALIZED VIEW statement is the same whether generated by OLAP Summary Advisor or the DBMS_ODM package.