16 CWM2_OLAP_METADATA_REFRESH

The CWM2_OLAP_METADATA_REFRESH package provides procedures that refresh the cached metadata tables used by the OLAP API.

See Also:

This chapter discusses the following topics:

Views of Cached OLAP Catalog Metadata
Views of Cached Active Catalog Metadata
Summary of CWM2_OLAP_METADATA_REFRESH Subprograms

16.1 Views of Cached OLAP Catalog Metadata

The Metadata Reader views, 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 queries by the OLAP API Metadata Reader.

The cache tables, unlike the OLAP Catalog model tables, are not automatically refreshed when changes are made to the metadata. You must call the MR_REFRESH procedure to refresh the cache tables.

Views of the OLAP Catalog model tables, described in Chapter 5, " OLAP Catalog Metadata Views ", have the prefix ALL_OLAP2. Most of the MRV_OLAP2 views have the same name and column structure as the corresponding ALL_OLAP2 views.

Note:

If the tables that underlie the MRV_OLAP2 views are not consistent with the OLAP Catalog metadata tables, the OLAP API may not be able to access the metadata.

16.2 Views of Cached Active Catalog Metadata

The MRV_OLAP2_AW views , present a read API to a set of cache tables for the Active Catalog. These views and tables are structured to facilitate query performance.

The cache tables, unlike the Active Catalog, are not automatically refreshed when changes are made to analytic workspaces. You must call the MR_AC_REFRESH procedure to refresh the cache tables.

The Active Catalog views, described in Chapter 3, " Active Catalog Views ", have the prefix ALL_OLAP2_AW. The MRV_OLAP2_AW views have the same name and column structure as the corresponding ALL_OLAP2_AW views.

Note:

If the tables that underlie the MRV_OLAP2_AW views are not consistent with the standard form metadata in analytic workspaces, you may not be able to obtain accurate information from them.

Summary of CWM2_OLAP_METADATA_REFRESH Subprograms

Table 16-1 CWM2_OLAP_METADATA_REFRESH Subprograms

Subprogram	Description
MR_REFRESH Procedure	Refreshes the cached metadata tables used by the OLAP API Metadata Reader.
MR_AC_REFRESH Procedure	Refreshes the cached Active Catalog metadata tables.

MR_REFRESH Procedure

This procedure refreshes the metadata tables that underlie the MRV_OLAP2 views. These tables must be updated to support queries by the OLAP API Metadata Reader.

Execute MR_REFRESH as the final statement in any script that creates, drops, or updates OLAP Catalog metadata for the OLAP API.

Execute MR_REFRESH after creating or modifying OLAP Catalog metadata in Enterprise Manager.

The MR_REFRESH procedure includes a COMMIT. The updates to the metadata tables are saved permanently in the database.

Syntax

MR_REFRESH;

MR_AC_REFRESH Procedure

This procedure refreshes the metadata tables that underlie the MRV_OLAP2_AW views. These tables must be updated to support queries against the Active Catalog cache tables.

Execute MR_AC_REFRESH as the final statement in any script that uses the DBMS_AWM package to create, modify, or enable analytic workspaces.

The MR_AC_REFRESH procedure includes a COMMIT.

Syntax

MR_AC_REFRESH;