[Home] [Help] [Dependency Information]
Object Name: | ALL_DIM_ATTRIBUTES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Representation of the relationship between a dimension level and
a functionally dependent column
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the dimentsion |
DIMENSION_NAME | VARCHAR2 | (128) | Yes | Name of the dimension |
ATTRIBUTE_NAME | VARCHAR2 | (128) | Name of the attribute | |
LEVEL_NAME | VARCHAR2 | (128) | Name of the hierarchy level | |
COLUMN_NAME | VARCHAR2 | (128) | Yes | Name of the dependent column |
INFERRED | CHAR | (1) | Whether this attribute is inferred from a JOIN KEY specification |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, DIMENSION_NAME
, ATTRIBUTE_NAME
, LEVEL_NAME
, COLUMN_NAME
, INFERRED
FROM SYS.ALL_DIM_ATTRIBUTES;
|
|
|