|Oracle9i OLAP User's Guide
Release 2 (22.214.171.124)
Part Number A95295-02
You should create materialized views after you have defined the OLAP metadata for your star schema.
Chapter 5, "Creating OLAP Catalog Metadata" for information about creating OLAP metadata.
If your OLAP metadata is visible within Enterprise Manager, you can use the OLAP Summary Advisor to create MVs in concatenated rollup form. You can also use the
DBMS_ODM package to create MVs in grouping set form.
If your OLAP metadata is not visible within Enterprise Manager, you must use the
DBMS_ODM package. Only grouping set style MVs are supported for this type of metadata.