Oracle教程 2023-02-25

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

本站中文解释

ALL_CUBE_DIMENSIONS视图是Oracle OLAP的系统视图，是指存在某个时点上OLAP数据库中被维度所涵盖的所有维度。视图包含下面几个字段：CUBE_NAME：指对应的多维数据块的名称；DIMENSION_UNIQUE_NAME：指维度的惟一名称；DIMENSION_NAME：指维度的名称；IS_SHARED：指是否是被多个数据块共享的维度；DIMENSION_TYPE：指维度的类型。

使用方法：
根据提供的维度信息，可以使用以下查询来检索ALL_CUBE_DIMENSIONS视图，以查看特定Cube中的所有维度：

SELECT * FROM ALL_CUBE_DIMENSIONS
WHERE CUBE_NAME = ‘PartSales’
ORDER BY DIMENSION_NAME;

官方英文解释

ALL_CUBE_DIMENSIONS describes the OLAP cube dimensions accessible to the current user.

Related Views

DBA_CUBE_DIMENSIONS describes all OLAP cube dimensions in the database.
USER_CUBE_DIMENSIONS describes the OLAP cube dimensions owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the cube dimension
`DIMENSION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of a cube dimension, such as `TIME`
`DIMENSION_ID`	`NUMBER`	`NOT NULL`	ID of the cube dimension
`DIMENSION_TYPE`	`VARCHAR2(17)`		Type of the OLAP cube dimension: `STANDARD` `TIME`
`AW_NAME`	`VARCHAR2(128)`		Name of the analytic workspace that contains the cube dimension, such as `GLOBAL`
`DEFAULT_HIERARCHY_NAME`	`VARCHAR2(128)`		Name of the default hierarchy for the cube dimension, such as `FISCAL`
`DESCRIPTION`	`NVARCHAR2(300)`		Description of the cube dimension in the session language
`HIERARCHY_CONSISTENCY_RULE`	`VARCHAR2(200)`		Hierarchy consistency rule of the OLAP cube dimension. Possible values: `CONSISTENT` `STAR_CONSISTENT` `SOLVE_CONSISTENT`
`ADD_UNIQUE_KEY_PREFIX`	`VARCHAR2(3)`		`Add_Unique_Key_Prefix` flag of the OLAP cube dimension. Possible values: YES: This is the value if `AddUniqueKeyPrefix="True"` was set in the metadata. This tells the system to add the level name prefix to the dimension members. This should be done when a dimension member can have the same value across different levels, for example, New York (state) and New York (city). NO: This is the value if `AddUniqueKeyPrefix="True"` was not set in the metadata.
`CUSTOM_ORDER`	`CLOB`		The textual representation of the sort orderby clause used to load dimension members into the AW

本站中文解释

官方英文解释

相关推荐