The OLAP API Metadata Reader Views

The Metadata Reader views present a read API to the OLAP Catalog. These views are structured to facilitate queries by the OLAP API Metadata Reader.

The Metadata Reader views, unlike the OLAP Catalog views described in Chapter 14, "Viewing OLAP Catalog Metadata", are not automatically refreshed when changes are made to the metadata.

The Metadata Reader views have public synonyms with the prefix MRV_OLAP. The union views have public synonyms with the prefix ALL_OLAP2. More than half of the MRV_OLAP views have the same name and column structure as the corresponding ALL_OLAP2 views.

The MRV_OLAP views and the ALL_OLAP2 views rely on separate sets of metadata tables. Whereas the tables that underlie the ALL_OLAP views are populated automatically, the tables that underlie the MRV_OLAP views must be explicitly refreshed whenever changes are made to the metadata.