Creating Materialized Views for the OLAP API, 4 of 7

Materialized Views and OLAP Metadata

You should create materialized views after you have defined the OLAP metadata for your star schema.

See Also:

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.