This chapter describes the relational views of standard form metadata in analytic workspaces.
This chapter discusses the following topics:
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.
The analytic workspace Active Catalog views are summarized in the following table.
Table 1-1 Active Catalog Views
PUBLIC Synonym | Description |
---|---|
List of dimension attributes in analytic workspaces |
|
Lists the measures in the measure folders |
|
Lists the measure folders in analytic workspaces |
|
List of levels in aggregation plans in analytic workspaces |
|
List of measures in aggregation plans in analytic workspaces |
|
List of aggregation operators in aggregation plans in analytic workspaces |
|
List of aggregation plans in analytic workspaces |
|
List of cubes with their associated dimensions in analytic workspaces |
|
List of cubes with their associated measures in analytic workspaces |
|
List of cubes in analytic workspaces |
|
List of hierarchical levels in analytic workspaces |
|
List of levels in analytic workspaces |
|
List of dimensions in analytic workspaces |
|
List of standard form objects in analytic workspaces |
|
List of properties associated with standard form objects in analytic workspaces |
|
Lists the analytic workspaces |
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.
ALL_OLAP2_AW_ATTRIBUTES
lists the attributes in standard form analytic workspaces.
Column | Datatype | NULL | 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
lists the measure folders in analytic workspaces.
Column | Datatype | NULL | 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
lists the measures in the measure folders.
Column | Datatype | NULL | 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
lists the cubes in standard form analytic workspaces.
Column | Datatype | NULL | 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
lists the levels in aggregation specifications in standard form analytic workspaces.
Column | Datatype | NULL | 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
lists the measures in aggregation specifications in standard form analytic workspaces.
Column | Datatype | NULL | 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
lists the aggregation operators in aggregation specifications in standard form analytic workspaces.
Column | Datatype | NULL | 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
lists the aggregation specifications in standard form analytic workspaces.
Column | Datatype | NULL | 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
lists the dimensions of cubes in standard form analytic workspaces.
Column | Datatype | NULL | 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
lists the measures of cubes in standard form analytic workspaces.
Column | Datatype | NULL | 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 |
ALL_OLAP2_AW_DIMENSIONS
lists the dimensions in standard form analytic workspaces.
Column | Datatype | NULL | 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
lists the levels in hierarchies in standard form analytic workspaces. It includes the position of each level within the hierarchy.
Column | Datatype | NULL | 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
lists the levels of dimensions in standard form analytic workspaces.
Column | Datatype | NULL | 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
lists the standard form objects in analytic workspaces.
Column | Datatype | NULL | 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
lists the standard form objects with their properties.