Skip Headers
Oracle® OLAP Reference
10g Release 2 (10.2)

Part Number B14350-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_AW_LOAD_CUBE_DIMS

ALL_AW_LOAD_CUBE_DIMS describes the composite specifications for cubes.

Composite specifications determines how the cube's dimensions will be optimized in the analytic workspace. Composite specifications are created by the DBMS_AWM.CREATE_AWCOMP_SPEC procedure.

Column Datatype NULL Description
cube_owner varchar2(240)
Owner of the OLAP Catalog source cube.
cube_name varchar2(240)
Name of the OLAP Catalog source cube.
cubeload_name varchar2(60)
Name of a load specification for the cube.
compspec_name varchar2(30)
Name of a composite specification associated with this load specification.
composite_name varchar2(30)
Name of a composite that is a member of the specification. A composite contains sparse dimensions of the cube.
segwidth number
Segment width for storage of the data dimensioned by this member of the specification.
compspec_position number
Position of the member within the specification.
dimension_owner varchar2(30)
Owner of an OLAP Catalog source dimension that is a member of the specification.
dimension_name varchar2(240)
Name of the OLAP Catalog source dimension that is a member of the specification.
composite_position number
Position of the member within a composite member.
nested_level number
The level of nesting of the member of the specification. For example, a dense dimension would have a nesting level of 1. A sparse dimension within a composite would have a nesting level of 2, and a nested composite would have a nesting level of 3.
nested_type varchar2(10)
Type of member of the specification. Either DIMENSION or COMPOSITE.
nested_name varchar2(30)
Name of the member of the specification. This may be the name of a dimension or the name of a composite.