Oracle教程 2023-02-23

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

ALL_CUBE_CALCULATED_MEMBERS 表组成了一个静态的，现有的计算成员的视图，这些成员可以分解到ALL_CUBE_CALCULATIONS 子视图。这个视图可以帮助查看某个cube里定义的计算及其关联维度成员。

使用ALL_CUBE_CALCULATED_MEMBERS视图可以实现查看Oracle cube上定义的计算及其关联维度成员，以便便于进行定制化的查询、编辑等操作。

使用例子：假设当前cube叫CUBE_A，要查询它里面定义的计算成员，可以使用以下语句：
SELECT * FROM ALL_CUBE_CALCULATED_MEMBERS WHERE CUBE_NAME=’CUBE_A’;

ALL_CUBE_CALCULATED_MEMBERS describes the calculated members for the OLAP cube dimensions accessible to the current user.

Related Views

DBA_CUBE_CALCULATED_MEMBERS describes the calculated members for all OLAP cube dimensions in the database.
USER_CUBE_CALCULATED_MEMBERS describes the calculated members for 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
`MEMBER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of a calculated member in the cube dimension
`IS_CUSTOM_AGGREGATE`	`VARCHAR2(3)`		Indicates whether the calculated member is a custom aggregate (`YES`) or not (`NO`)
`STORAGE_TYPE`	`VARCHAR2(10)`		Storage type of the calculated member: `DYNAMIC` – Value of the member is calculated for a query `PRECOMPUTE` – Value of the member is calculated and stored during data maintenance
`EXPRESSION`	`CLOB`		Expression used to generate the value of the calculated member