ALL_CUBE_ATTR_VISIBILITY

Previous Next JavaScript must be enabled to correctly display this content

2.135 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

DBA_CUBE_ATTR_VISIBILITY describes all OLAP attributes visible for the dimensions, hierarchies, and levels in the database.
USER_CUBE_ATTR_VISIBILITY describes the OLAP attributes visible for the dimensions, hierarchies, and levels owned by the current user. This view does not display the OWNER column.

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: