Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_CUBE_ATTR_VISIBILITY

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

Related Views

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.