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 theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the cube dimension |
|
|
|
Name of a cube dimension, such as |
|
|
|
ID of the cube dimension |
|
|
Type of the OLAP cube dimension:
|
|
|
|
Name of the analytic workspace that contains the cube dimension, such as |
|
|
|
Name of the default hierarchy for the cube dimension, such as |
|
|
|
Description of the cube dimension in the session language |
|
|
|
Hierarchy consistency rule of the OLAP cube dimension. Possible values:
|
|
|
|
|
|
|
|
The textual representation of the sort orderby clause used to load dimension members into the AW |
See Also:
-
“DBA_CUBE_DIMENSIONS”
-
“USER_CUBE_DIMENSIONS”