[Home] [Help] [Dependency Information]
Object Name: | CDB_CUBE_MEASURES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Measures in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the OLAP Measure |
CUBE_NAME | VARCHAR2 | (30) | Yes | Name of the OLAP Cube which owns the Measure |
MEASURE_NAME | VARCHAR2 | (128) | Yes | Name of Measure in the OLAP Cube |
MEASURE_ID | NUMBER | Yes | Dictionary Id of the Measure in the OLAP Cube | |
OVERRIDE_SOLVE_SPEC | CLOB | (4000) | Override solve specification of the OLAP Measure | |
MEASURE_TYPE | VARCHAR2 | (7) | Type of Measure in the OLAP Cube | |
EXPRESSION | CLOB | (4000) | Expression of the OLAP Measure | |
DESCRIPTION | NVARCHAR2 | (600) | Description of the OLAP Measure | |
DATA_TYPE | VARCHAR2 | (106) | Data Type of the OLAP Measure | |
DATA_LENGTH | NUMBER | Yes | Data Length of the OLAP Measure | |
DATA_PRECISION | NUMBER | Data Precision of the OLAP Measure | ||
DATA_SCALE | NUMBER | Data Scale of the OLAP Measure | ||
LOOP_VAR_OVERRIDE | VARCHAR2 | (200) | Override $LOOP_VAR of the OLAP Measure | |
LOOP_DENSE_OVERRIDE | VARCHAR2 | (200) | Override $LOOP_DENSE of the OLAP Measure | |
LOOP_TYPE | VARCHAR2 | (200) | $LOOP_TYPE of the OLAP Measure | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, CUBE_NAME
, MEASURE_NAME
, MEASURE_ID
, OVERRIDE_SOLVE_SPEC
, MEASURE_TYPE
, EXPRESSION
, DESCRIPTION
, DATA_TYPE
, DATA_LENGTH
, DATA_PRECISION
, DATA_SCALE
, LOOP_VAR_OVERRIDE
, LOOP_DENSE_OVERRIDE
, LOOP_TYPE
, CON_ID
FROM SYS.CDB_CUBE_MEASURES;
SYS.CDB_CUBE_MEASURES does not reference any database object
SYS.CDB_CUBE_MEASURES is referenced by following:
|
|
|