Oracle教程 2023-02-23

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

是Oracle DW维度建模体系结构中的一个数据字典视图，用于存放 DWCube（数据仓库立方体）的度量属性定义，包括每个度量的类型、描述、如何计算等等。ALL_CUBE_MEASURES 的字段有MEASURE_NAME、MEASURE_TYPE、MEASURE_DESC、CALC_TYPE等。

使用 ALL_CUBE_MEASURES 视图时，首先要根据特定查询条件选择查询字段，然后使用 SELECT 语句，带上条件表达式选择ALL_CUBE_MEASURES视图中字段的内容。例如：

SELECT MEASURE_NAME, MEASURE_TYPE, MEASURE_DESC FROM ALL_CUBE_MEASURES WHERE CALC_TYPE = ‘Sum’;

上述操作可以选择所有被求和的度量的名称、类型和描述。

ALL_CUBE_MEASURES describes the measures for the OLAP cubes accessible to the current user.

Related Views

DBA_CUBE_MEASURES describes the measures for all OLAP cubes in the database.
USER_CUBE_MEASURES describes the measures 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`
`MEASURE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of a measure in the cube, such as `SALES`
`MEASURE_ID`	`NUMBER`	`NOT NULL`	ID of a measure
`OVERRIDE_SOLVE_SPEC`	`CLOB`		Syntax text for the measure’s consistent solve specification that overrides that of its cube
`MEASURE_TYPE`	`VARCHAR2(7)`		Type of the OLAP measure: `BASE` – Base measures store the data `DERIVED` – Derived measures calculate the data from base measures; also called calculated measures
`EXPRESSION`	`CLOB`		Expression that provides the values of the measure
`DESCRIPTION`	`NVARCHAR2(300)`		Description of the measure in the session language
`DATA_TYPE`	`VARCHAR2(106)`		Data type of the measure, such as `NUMBER`
`DATA_LENGTH`	`NUMBER`	`NOT NULL`	Length of a character data type
`DATA_PRECISION`	`NUMBER`		Precision of a numeric data type
`DATA_SCALE`	`NUMBER`		Scale of a numeric data type
`LOOP_VAR_OVERRIDE`	`VARCHAR2(200)`		The value that overrides the `$LOOP_VAR` property of the OLAP derived measure
`LOOP_DENSE_OVERRIDE`	`VARCHAR2(200)`		The value that overrides the `$LOOP_DENSE` property of the OLAP derived measure
`LOOP_TYPE`	`VARCHAR2(200)`		The `$LOOP_TYPE` property of the OLAP derived measure. Possible values: `INNER` `OUTER` `DENSE`