[Home] [Help] [Dependency Information]
Object Name: | CDB_CUBE_CALCULATED_MEMBERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Calculated Members in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the OLAP Calculated Member |
DIMENSION_NAME | VARCHAR2 | (30) | Yes | Name of owning dimension of the OLAP Calculated Member |
MEMBER_NAME | VARCHAR2 | (128) | Yes | Member Name of the OLAP Calculated Member |
IS_CUSTOM_AGGREGATE | VARCHAR2 | (3) | Custom Aggregate flag of the OLAP Calculated Member | |
STORAGE_TYPE | VARCHAR2 | (10) | Storage Type of the OLAP Calculated Member | |
EXPRESSION | CLOB | (4000) | Expression of the OLAP Calculated Member | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, DIMENSION_NAME
, MEMBER_NAME
, IS_CUSTOM_AGGREGATE
, STORAGE_TYPE
, EXPRESSION
, CON_ID
FROM SYS.CDB_CUBE_CALCULATED_MEMBERS;
SYS.CDB_CUBE_CALCULATED_MEMBERS does not reference any database object
SYS.CDB_CUBE_CALCULATED_MEMBERS is referenced by following:
|
|
|