Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

Part Number A95295-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

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.