Oracle® OLAP Reference 10g Release 1 (10.1) Part Number B10334-02 |
|
|
View PDF |
The CWM2_OLAP_METADATA_REFRESH
package provides procedures that refresh the cached metadata tables used by the OLAP API.
This chapter discusses the following topics:
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 theMRV_OLAP2 views are not consistent with the OLAP Catalog metadata tables, the OLAP API may not be able to access the 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 theMRV_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. |
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. |
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;
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;