1 Active Catalog Views

This chapter describes the relational views of standard form metadata in analytic workspaces.

This chapter discusses the following topics:

Understanding the Active Catalog
Summary of Active Catalog Views

Understanding the Active Catalog

OLAP processing depends on a data model composed of cubes, measures, dimensions, hierarchies, levels, and attributes. Standard form metadata defines the logical model and is stored in the analytic workspaces. Views of this metadata are commonly referred to as the Active Catalog, because they are populated automatically and always reflect the current state of the analytic workspace.

Active Catalog views provide information about standard form objects in all analytic workspaces accessible to the current user.

The Active Catalog views are named with the ALL_OLAP2_AW prefix.

Summary of Active Catalog Views

The analytic workspace Active Catalog views are summarized in the following table.

Table 1-1 Active Catalog Views

PUBLIC Synonym	Description
ALL_OLAP2_AW_ATTRIBUTES	List of dimension attributes in analytic workspaces
ALL_OLAP2_AW_CATALOG_MEASURES	Lists the measures in the measure folders
ALL_OLAP2_AW_CATALOGS	Lists the measure folders in analytic workspaces
ALL_OLAP2_AW_CUBE_AGG_LVL	List of levels in aggregation plans in analytic workspaces
ALL_OLAP2_AW_CUBE_AGG_MEAS	List of measures in aggregation plans in analytic workspaces
ALL_OLAP2_AW_CUBE_AGG_OP	List of aggregation operators in aggregation plans in analytic workspaces
ALL_OLAP2_AW_CUBE_AGG_SPECS	List of aggregation plans in analytic workspaces
ALL_OLAP2_AW_CUBE_DIM_USES	List of cubes with their associated dimensions in analytic workspaces
ALL_OLAP2_AW_CUBE_MEASURES	List of cubes with their associated measures in analytic workspaces
ALL_OLAP2_AW_CUBES	List of cubes in analytic workspaces
ALL_OLAP2_AW_DIM_HIER_LVL_ORD	List of hierarchical levels in analytic workspaces
ALL_OLAP2_AW_DIM_LEVELS	List of levels in analytic workspaces
ALL_OLAP2_AW_DIMENSIONS	List of dimensions in analytic workspaces
ALL_OLAP2_AW_PHYS_OBJ	List of standard form objects in analytic workspaces
ALL_OLAP2_AW_PHYS_OBJ_PROP	List of properties associated with standard form objects in analytic workspaces
ALL_OLAP2_AWS	Lists the analytic workspaces

ALL_OLAP2_AWS

ALL_OLAP2_AWS provides a list of all the analytic workspaces accessible to the current user. This includes both standard form and non-standard analytic workspaces.

Column	Datatype	Description
`OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_NUMBER`	`NUMBER`	Unique identifier for the analytic workspace
`AW_VERSION`	`VARCHAR2(4)`	The version of the Oracle database in which the analytic workspace was created If the version is 10.1 or higher, the workspace is in 10g storage format. Earlier versions are in 9i format.
`SF_VERSION`	`VARCHAR2(8)`	The version of the Oracle database in which the standard form metadata was created

ALL_OLAP2_AW_ATTRIBUTES

ALL_OLAP2_AW_ATTRIBUTES lists the attributes in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_DIMENSION_NAME`	`VARCHAR2(4000)`	Name of the dimension in the analytic workspace
`AW_LOGICAL_NAME`	`VARCHAR2(90)`	Logical name for the attribute in the analytic workspace
`AW_PHYSICAL_OBJECT`	`VARCHAR2(4000)`	Standard form name for the attribute in the analytic workspace
`DISPLAY_NAME`	`VARCHAR2(4000)`	Display name for the attribute
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the attribute
`ATTRIBUTE_TYPE`	`VARCHAR2(4000)`	Type of attribute
`SOURCE_OWNER`	`VARCHAR2(4000)`	Owner of the source attribute in the OLAP Catalog (Oracle9i metadata)
`SOURCE_DIMENSION_NAME`	`VARCHAR2(4000)`	Name of the source dimension in the OLAP Catalog (Oracle9i metadata)
`SOURCE_NAME`	`VARCHAR2(4000)`	Name of the source attribute in the OLAP Catalog (Oracle9i metadata)

ALL_OLAP2_AW_CATALOGS

ALL_OLAP2_AW_CATALOGS lists the measure folders in analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`CATALOG_ID`	`NUMBER`	Unique identifier for the measure folder
`CATALOG_NAME`	`VARCHAR2(4000)`	Name of the measure folder
`PARENT_CATALOG_NAME`	`VARCHAR2(4000)`	Name of the parent folder when `CATALOG_NAME` is a subfolder
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the measure folder

ALL_OLAP2_AW_CATALOG_MEASURES

ALL_OLAP2_AW_CATALOG_MEASURES lists the measures in the measure folders.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`CATALOG_ID`	`NUMBER`	Unique identifier for the measure folder
`CATALOG_NAME`	`VARCHAR2(4000)`	Name of the measure folder
`ENTITY_OWNER`	`VARCHAR2(4000)`	Owner of the cube
`ENTITY_NAME`	`VARCHAR2(4000)`	Name of the cube with the measure
`CHILD_ENTITY_NAME`	`VARCHAR2(4000)`	Name of the measure included in the folder

ALL_OLAP2_AW_CUBES

ALL_OLAP2_AW_CUBES lists the cubes in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_LOGICAL_NAME`	`VARCHAR2(90)`	Logical name for the cube in the analytic workspace
`AW_PHYSICAL_OBJECT`	`VARCHAR2(4000)`	Standard form name for the cube in the analytic workspace
`SOURCE_OWNER`	`VARCHAR2(4000)`	Owner of the source cube in the OLAP Catalog (Oracle9i metadata)
`SOURCE_NAME`	`VARCHAR2(4000)`	Name of the source cube in the OLAP Catalog (Oracle9i metadata)

ALL_OLAP2_AW_CUBE_AGG_LVL

ALL_OLAP2_AW_CUBE_AGG_LVL lists the levels in aggregation specifications in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_CUBE_NAME`	`VARCHAR2(90)`	Name of a cube in the analytic workspace
`AW_AGGSPEC_NAME`	`VARCHAR2(4000)`	Name of an aggregation specification for the cube
`AW_DIMENSION_NAME`	`VARCHAR2(4000)`	Name of a workspace dimension of the cube
`AW_LEVEL_NAME`	`VARCHAR2(4000)`	Name of a level of the dimension, which is in the aggregation specification

ALL_OLAP2_AW_CUBE_AGG_MEAS

ALL_OLAP2_AW_CUBE_AGG_MEAS lists the measures in aggregation specifications in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_CUBE_NAME`	`VARCHAR2(90)`	Name of a cube in the analytic workspace
`AW_AGGSPEC_NAME`	`VARCHAR2(4000)`	Name of an aggregation specification for the cube
`AW_MEASURE_NAME`	`VARCHAR2(4000)`	Name of a measure of the cube, which is in the aggregation specification

ALL_OLAP2_AW_CUBE_AGG_OP

ALL_OLAP2_AW_CUBE_AGG_OP lists the aggregation operators in aggregation specifications in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_CUBE_NAME`	`VARCHAR2(90)`	Name of a cube in the analytic workspace
`AW_MEASURE_NAME`	`VARCHAR2`	Name of a workspace measure to aggregate
`AW_AGGSPEC_NAME`	`VARCHAR2(4000)`	Name of an aggregation specification for the cube
`AW_DIMENSION_NAME`	`VARCHAR2(4000)`	Name of a workspace dimension of the cube
`OPERATOR`	`VARCHAR2(4000)`	Operator for aggregation along this dimension

ALL_OLAP2_AW_CUBE_AGG_SPECS

ALL_OLAP2_AW_CUBE_AGG_SPECS lists the aggregation specifications in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_CUBE_NAME`	`VARCHAR2(90)`	Name of the cube in the analytic workspace
`AW_AGGSPEC_NAME`	`VARCHAR2(4000)`	Name of an aggregation plan for the cube

ALL_OLAP2_AW_CUBE_DIM_USES

ALL_OLAP2_AW_CUBE_DIM_USES lists the dimensions of cubes in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_LOGICAL_NAME`	`VARCHAR2(90)`	Name of a cube in the analytic workspace
`DIMENSION_AW_OWNER`	`VARCHAR2(4000)`	Owner of a workspace dimension of the cube
`DIMENSION_AW_NAME`	`VARCHAR2(4000)`	Name of a workspace dimension of the cube
`DIMENSION_SOURCE_OWNER`	`VARCHAR2(4000)`	Owner of the source dimension in the OLAP Catalog (Oracle9i metadata)
`DIMENSION_SOURCE_NAME`	`VARCHAR2(4000)`	Name of the source dimension in the OLAP Catalog (Oracle9i metadata)

ALL_OLAP2_AW_CUBE_MEASURES

ALL_OLAP2_AW_CUBE_MEASURES lists the measures of cubes in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_CUBE_NAME`	`VARCHAR2(90)`	Name of a cube in the analytic workspace
`AW_MEASURE_NAME`	`VARCHAR2(4000)`	Logical name of a measure of the cube
`AW_PHYSICAL_OBJECT`	`VARCHAR2(4000)`	Standard form name of the measure
`MEASURE_SOURCE_NAME`	`VARCHAR2(4000)`	Name of the source measure in the OLAP Catalog (Oracle9i metadata)
`DISPLAY_NAME`	`VARCHAR2(4000)`	Display name for the measure in the analytic workspace
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the measure in the analytic workspace
`IS_AGGREGATEABLE`	`VARCHAR2(4000)`	Whether or not this measure can be aggregated The value is `YES` if the measure is implemented as an OLAP variable or if its underlying storage is a variable. For example, the measure could be implemented as a formula whose value is stored in a variable.

ALL_OLAP2_AW_DIMENSIONS

ALL_OLAP2_AW_DIMENSIONS lists the dimensions in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_LOGICAL_NAME`	`VARCHAR2(90)`	Logical name of the dimension in the analytic workspace
`AW_PHYSICAL_OBJECT`	`VARCHAR2(4000)`	Standard form name of the dimension in the analytic workspace
`SOURCE_OWNER`	`VARCHAR2(4000)`	Owner of the source dimension in the OLAP Catalog (Oracle9i metadata)
`SOURCE_NAME`	`VARCHAR2(4000)`	Name of the source dimension in the OLAP Catalog (Oracle9i metadata)

ALL_OLAP2_AW_DIM_HIER_LVL_ORD

ALL_OLAP2_AW_DIM_HIER_LVL_ORD lists the levels in hierarchies in standard form analytic workspaces. It includes the position of each level within the hierarchy.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_DIMENSION_NAME`	`VARCHAR2(90)`	Name of a dimension in the analytic workspace
`AW_HIERARCHY_NAME`	`VARCHAR2(4000)`	Name of a hierarchy of the workspace dimension
`IS_DEFAULT_HIER`	`VARCHAR2(4000)`	Whether or not this hierarchy is the default hierarchy
`AW_LEVEL_NAME`	`VARCHAR2(4000)`	Name of a level of the workspace hierarchy
`POSITION`	`NUMBER`	The position of the level in the hierarchy

ALL_OLAP2_AW_DIM_LEVELS

ALL_OLAP2_AW_DIM_LEVELS lists the levels of dimensions in standard form analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_LOGICAL_NAME`	`VARCHAR2(90)`	Name of a dimension in the analytic workspace
`LEVEL_NAME`	`VARCHAR2(4000)`	Name of a workspace level of the dimension
`DISPLAY_NAME`	`VARCHAR2(4000)`	Display name of the level
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the level

ALL_OLAP2_AW_PHYS_OBJ

ALL_OLAP2_AW_PHYS_OBJ lists the standard form objects in analytic workspaces.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_OBJECT_NAME`	`VARCHAR2(90)`	Name of the standard form object in the analytic workspace
`AW_OBJECT_TYPE`	`VARCHAR2(4000)`	Type of the standard form object The type may be any of the native object types that can be defined within an analytic workspace, including dimensions, relations, variables, formulas, composites, and valuesets.
`AW_OBJECT_DATATYPE`	`VARCHAR2(4000)`	Data type of the standard form object The data type may be any of the native types supported by analytic workspaces, including text, boolean, or integer, or it may be a defined type specific to standard form.

ALL_OLAP2_AW_PHYS_OBJ_PROP

ALL_OLAP2_AW_PHYS_OBJ_PROP lists the standard form objects with their properties.

Column	Datatype	Description
`AW_OWNER`	`VARCHAR2(30)`	Owner of the analytic workspace
`AW_NAME`	`VARCHAR2(30)`	Name of the analytic workspace
`AW_OBJECT_NAME`	`VARCHAR2(90)`	Name of the standard form object in the analytic workspace
`AW_PROP_NAME`	`VARCHAR2(4000)`	Name of a property of the standard form object
`AW_PROP_VALUE`	`VARCHAR2(4000)`	Value of the property