[Home] [Help] [Dependency Information]
Object Name: | USER_CUBE_CALCULATED_MEMBERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Calculated Members in the database accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_NAME | VARCHAR2 | (128) | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT DIMENSION_NAME
, MEMBER_NAME
, IS_CUSTOM_AGGREGATE
, STORAGE_TYPE
, EXPRESSION
FROM SYS.USER_CUBE_CALCULATED_MEMBERS;
|
|
|