ALL_OLAP2_CATALOGS

ALL_OLAP2_CATALOGS is a synonym for ALL$OLAP2UCATALOGS.

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 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. The OLAP metadata classification system, implemented in the OLAP 1 Catalog, is used by both releases of the OLAP Catalog.

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