Understanding the OLAP Classification System

The CWM_CLASSIFY package, implementing the OLAP classification system, is used primarily to manipulate OLAP measure folders.

The OLAP classification system is the single area of overlap between the CWM and CWM2 versions the OLAP Catalog.

The CWM_CLASSIFY package is part of CWM, the metadata repository that underlies the OLAP Management feature of Oracle Enterprise Manager. However, the classification system is also used by CWM2, the new metadata repository that is available via the PL/SQL packages whose names start with CWM2_OLAP.

Note: Although the CWM_CLASSIFY package manages measure folders for both metadata management systems, the measures stored within measure folders are specific to either CWM and CWM2. Measures created by Enterprise Manager cannot be accessed by CWM2 procedures, and measures created by CWM2 procedures are not visible within Enterprise Manager.