ALL_CUBE_CALCULATED_MEMBERS

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(30)`	`NOT NULL`	Owner of the cube dimension
`DIMENSION_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of a cube dimension
`MEMBER_NAME`	`VARCHAR2(30)`	`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