Viewing OLAP Catalog Metadata

A set of views, identified by the ALL_OLAP2 prefix, presents the metadata in the OLAP Catalog. The metadata may have been created with the CWM2 PL/SQL packages, with Enterprise Manager, or with Warehouse Builder. The ALL_OLAP2 views are automatically populated whenever changes are made to the metadata.

A second set of views, identified by the MRV_OLAP prefix, also presents OLAP Catalog metadata. These views are used by the OLAP API to access data stored in relational tables, typically star schemas. These views are structured specifically to support fast querying by the OLAP API Metadata Reader. They must be explicitly refreshed whenever changes are made to the metadata.