Views of Cached Active Catalog Metadata

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

The MRV_OLAP2_AW views correspond to the ALL_OLAP2_AW views, which provide information about standard form metadata within analytic workspaces. Each MRV_OLAP2_AW view has the same name and column structure as its corresponding ALL_OLAP2_AW view. If you require fast access to the Active Catalog, you should query the cached metadata through the MRV_OLAP2_AW views.

The cache tables are not automatically refreshed when changes are made to the Active Catalog. To refresh the cache, call the CWM2_OLAP_METADATA_REFRESH.MR_AC_REFRESH procedure.

Note:

If your data is stored in analytic workspaces, you should refresh the Active Catalog cache for applications that use the OLAP API.

Summary of CWM2_OLAP_METADATA_REFRESH Subprograms

Table 19-1 CWM2_OLAP_METADATA_REFRESH Subprograms

Subprogram	Description
MR_REFRESH Procedure	Refreshes the OLAP Catalog metadata cache.
MR_AC_REFRESH Procedure	Refreshes the Active Catalog metadata cache.

MR_REFRESH Procedure

This procedure refreshes the OLAP Catalog metadata cache tables that underlie the MRV_OLAP2 views. You must refresh the cache for applications that use the OLAP API with a relational data source.

The MR_REFRESH procedure includes a COMMIT.

Syntax

MR_REFRESH;

MR_AC_REFRESH Procedure

This procedure refreshes the Active Catalog metadata cache tables that underlie the MRV_OLAP2_AW views. You must refresh the cache for applications that use the OLAP API with a multidimensional data source in analytic workspaces.

The MR_AC_REFRESH procedure includes a COMMIT.

Syntax

MR_AC_REFRESH;