| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
The OLAP Catalog views present information stored in the base tables of the OLAP Catalog. This information is also stored for fast access in a separate set of cache tables.
The OLAP Catalog views are named with the ALL_OLAP2 or DBA_OLAP2 prefix. The views of the cache tables, which have the same column structure, are named with the MRV_OLAP2 prefix.
Applications that require fast access to OLAP Catalog metadata should query the cached metadata in the MRV_OLAP2 views.
The metadata cache is not automatically refreshed when changes are made to the base metadata tables. To refresh the cache, use the CWM2_OLAP_METADATA_REFRESH package.
|
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. |
