[Home] [Help] [Dependency Information]
Object Name: | ALL_CUBE_MEASURES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Measures in the database accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the OLAP Measure |
CUBE_NAME | VARCHAR2 | (128) | 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 | ||
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 |
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
FROM SYS.ALL_CUBE_MEASURES;
|
|
|