Oracle教程 2023-02-23

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

Oracle视图ALL_CUBE_DIMENSIONALITY用于查询已存在的多维数据库中的维度及其相应的属性。

ALL_CUBE_DIMENSIONALITY视图保存着以下信息：

– 在哪个维度中定义了维度
– 哪些属性是此维度的一部分
– 每个属性的数据类型
– 每个维度在哪个表中可用
– 每个维度能表示的总维度数

使用ALL_CUBE_DIMENSIONALITY视图的最核心的目的是查询用于构建多维数据库的表。它也提供有关在这些表中构建的维度的详细信息，包括每个维度的属性和属性的数据类型。

要使用ALL_CUBE_DIMENSIONALITY视图，首先必须在数据库中创建和定义多维模型。接着，可以使用它来查询多维数据库中可用的维度及其属性。示例语句如下：

SELECT *
FROM ALL_CUBE_DIMENSIONALITY
WHERE CUBE_NAME = ‘MY_CUBE’;

使用此查询语句可以检索“MY_CUBE”多维数据库中的所有维度及其属性的完整列表。

ALL_CUBE_DIMENSIONALITY describes the dimension order for the OLAP cubes accessible to the current user.

Related Views

DBA_CUBE_DIMENSIONALITY describes the dimension order for all OLAP cubes in the database.
USER_CUBE_DIMENSIONALITY describes the dimension order for the OLAP cubes 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
`CUBE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of a cube, such as `UNITS_CUBE`
`DIMENSION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of a dimension of the cube, such as `PRODUCT`
`DIMENSIONALITY_NAME`	`VARCHAR2(200)`		The name of a dimensionality of the cube. For example, a cube dimensioned by the `PRODUCT` dimension can have a product dimension named `PRODUCT_DIM`.
`DIMENSIONALITY_ID`	`NUMBER`	`NOT NULL`	ID of the cube dimensionality
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order number of the dimension in the cube
`IS_SPARSE`	`NUMBER`		Indicates whether the dimension is sparse in the cube (`1`) or not sparse (`0`)
`ET_ATTR_PREFIX`	`VARCHAR2(200)`		Specifies the prefix that will be added to the column names in the Materialized Views to ensure uniqueness. If the user does not specify an `ET_ATTR_PREFIX` for any dimensions in a cube, then they default in the pattern `D1_`, `D2_`, and so on.