Enabling Access by the OLAP API

Analytic workspaces created with the current DBMS_AWM package or Analytic Workspace Manager automatically support queries by the OLAP API and BI Beans. You do not need to create relational views, abstract data types, or OLAP Catalog metadata to enable access. Current standard form metadata supports the automatic generation of the mapping information needed by OLAP queries at runtime.

The DBMS_AWM package will attempt to upgrade the standard form metadata when it attaches a workspace created in a previous version. You can explicitly upgrade the metadata with a one-time call to the CREATE_DYNAMIC_AW_ACCESS procedure. The workspace must already be in 10g storage format before the metadata can be upgraded.

If you choose not to upgrade to the current standard form, you can continue to use the DBMS_AWM enablement procedures as you did in previous releases. The relational views, abstract data types, and OLAP Catalog metadata will still be valid. However, any views, abstract data types, and OLAP Catalog metadata associated with upgraded analytic workspaces will be ignored by the OLAP API.