DBA dimension views

Our Remote DBA Clients
Oracle Tips by Burleson
DBA dimension views
DBA_DIMENSIONS
Description of the dimension objects accessible to the DBA
------------------------------------------------------------------------------------
OWNER 		VARCHAR2 	Owner of the dimension
DIMENSION_NAME 	VARCHAR2 	Name of the dimension
INVALID 		VARCHAR2 	Invalidity of the dimension, Y = INVALID, N = VALID.
The column is deprecated, please use COMPILE_STATE instead.
COMPILE_STATE 	VARCHAR2 Compile status of the dimension, VALID/NEEDS_COMPILE/ERROR
REVISION NUMBER Revision levle of the dimension


DBA_DIM_ATTRIBUTES
Representation of the relationship between a dimension level and
a functionally dependent column
------------------------------------------------------------------------------------
OWNER 		VARCHAR2 	Owner of the dimentsion
DIMENSION_NAME 	VARCHAR2 	Name of the dimension
ATTRIBUTE_NAME 	VARCHAR2 	Name of the attribute
LEVEL_NAME 	VARCHAR2 	Name of the hierarchy level
COLUMN_NAME 	VARCHAR2 	Name of the dependent column
INFERRED 		CHAR 	Whether this attribute is inferred from a JOIN KEY specification


DBA_DIM_CHILD_OF
Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension
------------------------------------------------------------------------------------
OWNER 		VARCHAR2 	Owner of the dimension
DIMENSION_NAME 	VARCHAR2 	Name of the dimension
HIERARCHY_NAME 	VARCHAR2 	Name of the hierarchy
POSITION 		NUMBER 	Hierarchical position within this hierarchy, position 1 being
the most detailed
CHILD_LEVEL_NAME 	VARCHAR2 	Name of the child-side level of this 1:n relationship
JOIN_KEY_ID 	VARCHAR2 	Keys that join child to the parent
PARENT_LEVEL_NAME 	VARCHAR2 	Name of the parent-side level of this 1:n relationship


DBA_DIM_HIERARCHIES
Representation of a dimension hierarchy
------------------------------------------------------------------------------------
OWNER 		VARCHAR2 	Owner of the dimension
DIMENSION_NAME 	VARCHAR2 	Name of the dimension
HIERARCHY_NAME 	VARCHAR2 	Name of the hierarchy


DBA_DIM_JOIN_KEY
Representation of a join between two dimension tables.
------------------------------------------------------------------------------------
OWNER 		VARCHAR2 	Owner of the dimension
DIMENSION_NAME 	VARCHAR2 	Name of the dimension
DIM_KEY_ID 	NUMBER 	Join key ID (unique within a dimension)
LEVEL_NAME 	VARCHAR2 	Name of the hierarchy level
KEY_POSITION 	NUMBER 	Position of the key column within the level
HIERARCHY_NAME 	VARCHAR2 	Name of the hierarchy
CHILD_JOIN_OWNER 	VARCHAR2 	Owner of the join column table
CHILD_JOIN_TABLE 	VARCHAR2 	Name of the join column table
CHILD_JOIN_COLUMN 	VARCHAR2 	Name of the join column
CHILD_LEVEL_NAME 	VARCHAR2 	Name of the child hierarchy level of the join key


DBA_DIM_LEVELS
Description of dimension levels visible to DBA
------------------------------------------------------------------------------------
OWNER 		VARCHAR2 	Owner of the dimension
DIMENSION_NAME 	VARCHAR2 	Name of the dimension
LEVEL_NAME 	VARCHAR2 	Name of the dimension level (unique within a dimension)
NUM_COLUMNS 	NUMBER 	Number of columns in the level definition
DETAILOBJ_OWNER 	VARCHAR2 	Owner of the detail object that the keys of this level come from
DETAILOBJ_NAME 	VARCHAR2 	Name of the table that the keys of this level come from
SKIP_WHEN_NULL 	VARCHAR2


DBA_DIM_LEVEL_KEY
Representations of columns of a dimension level
------------------------------------------------------------------------------------
OWNER 		VARCHAR2 	Owner of the dimension
DIMENSION_NAME 	VARCHAR2 	Name of the dimension
LEVEL_NAME 	VARCHAR2 	Name of the hierarchy level
KEY_POSITION 	NUMBER 	Ordinal position of the key column within the level
COLUMN_NAME 	VARCHAR2 	Name of the key column