ALL_CUBE_ATTR_VISIBILITY

ALL_CUBE_ATTR_VISIBILITY describes the OLAP attributes visible for the dimensions, hierarchies, and levels accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the cube dimension
DIMENSION_NAME VARCHAR2(128)   Name of a cube dimension (such as TIME)
ATTRIBUTE_NAME VARCHAR2(128)   Name of an attribute of the dimension (such as LONG_DESCRIPTION or END_DATE)
HIERARCHY_NAME VARCHAR2(128)   Name of a hierarchy for the dimension (such as CALENDAR)
LEVEL_NAME VARCHAR2(128)   Name of the dimension level (such as MONTH)
FROM_TYPE VARCHAR2(10)  

Identifies the dimension type that the current row derives the attribute visibility from. Possible values:

  • DIMENSION - Derives the attribute visibility from itself.

  • HIERARCHY - Derives the attribute visibility from the VisibleAttributes explicitly set on the associated DIMENSION or itself.

  • DIM_LEVEL - Derives the attribute visibility from the VisibleAttributes explicitly set on the associated DIMENSION or itself.

  • HIER_LEVEL - Derives the attribute visibility from the VisibleAttributes explicitly set on the associated DIMENSION, HIERARCHY, DIM_LEVEL, or itself.

TO_TYPE VARCHAR2(10)  

Identifies the dimension type for the current row. Possible values:

  • DIMENSION - When the TO_TYPE is DIMENSION, then only the DIMENSION_NAME is populated.

  • HIERARCHY - When the TO_TYPE is HIERARCHY, then only the DIMENSION_NAME and HIERARCHY_NAME are populated.

  • DIM_LEVEL - When the TO_TYPE is DIM_LEVEL, then only the DIMENSION_NAME and LEVEL_NAME are populated.

  • HIER_LEVEL - When the TO_TYPE is HIER_LEVEL, then only the HIERARCHY_NAME and LEVEL_NAME are populated.

See Also: