Views of Cached OLAP Catalog Metadata

The Metadata Reader Views for the OLAP Catalog, named with the prefix MRV_OLAP2, present a read API to a set of cache tables for OLAP Catalog metadata. These views and tables are structured to facilitate query performance for the OLAP API.

The MRV_OLAP2 views correspond to the ALL_OLAP2 views, which provide information about OLAP Catalog metadata. Each MRV_OLAP2 view has the same name and column structure as its corresponding ALL_OLAP2 view. If you require fast access to OLAP Catalog metadata, you should query the cached metadata through the MRV_OLAP2 views.

The cache tables are not automatically refreshed when changes are made to the metadata. To refresh the cache, call the CWM2_OLAP_METADATA_REFRESH.MR_REFRESH procedure.

Note:

If your data is stored in relational tables (not in analytic workspaces), you must refresh the OLAP Catalog metadata cache for applications that use the OLAP API.