ALL$OLAP2_CATALOGS

Each row represents an OLAP measure folder (catalog). Measure folders are a means of grouping measures related to a given business area. For instance, all the measures that store information about a given product line might be collected in a measure folder.

Measure folders are schema independent. All users can view all the measure folders defined in the database, even if they do not have access privileges for the measures within the folders.

Measure folders can be nested within other measure folders.

Note: The classification system (CWM_CLASSIFY), used to manage measure folders and classify various OLAP metadata entities, is implemented in CWM and referenced from CWM2. Only CWM2 measure folders are displayed by ALL$OLAP2_CATALOG_ENTITY_USES.

Note: The term catalog, when used in the context of the classification system, refers to a measure folder. It should not be confused with the term OLAP Catalog, which refers to the collection of tables that implement the OLAP metadata model.

Column	Datatype	NULL	Description
CATALOG_ID	NUMBER	NOT NULL	ID of the measure folder (from OLAP 1 Catalog).
CATALOG_NAME	VARCHAR2(30)	NOT NULL	Name of the measure folder (from OLAP 1 Catalog).
PARENT_CATALOG_ID	NUMBER		ID of the parent measure folder (from OLAP 1 Catalog). This column is null for measure folders at the root of the measure folder tree.
DESCRIPTION	VARCHAR2(2000)		Description of the measure folder (from OLAP 1 Catalog).