Oracle教程 2023-02-27

Oracle 视图 ALL_CUBE_ATTR_VISIBILITY 官方解释，作用，如何使用详细说明

本站中文解释

ALL_CUBE_ATTR_VISIBILITY是Oracle系统提供的一个视图，它主要用于显示当前用户可访问的OLAP cube的属性权限。

ALL_CUBE_ATTR_VISIBILITY视图由以下栏位构成：

CUBE_NAME：OLAP cube 的名称；

MEASURE_NAME： OLAP cube 中指标因素的名称；

ATTR_NAME： OLAP cube 中维属性的名称；

ATTR_TYPE： OLAP cube 属性的隐藏性，“VISIBLE”表明OLAP cube 属性是可见的，“HIDDEN”表明OLAP cube 属性是不可见的；

ATTR_LEVEL：属性的层次；

USER_NAME：表示当前用户的名称。

使用ALL_CUBE_ATTR_VISIBILITY视图，用户能够查看OLAP cube 的属性权限，并快速了解自己当前可操作属性的特性，有助于用户管理自己所关心的OLAP cube, 节省管理时间，提高效率。

官方英文解释

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	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.

本站中文解释

官方英文解释

相关推荐