| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
ALL_CUBE_MEASURES describes the measures for the OLAP cubes accessible to the current user.
Related Views
DBA_CUBE_MEASURES describes the measures for all OLAP cubes in the database.
USER_CUBE_MEASURES describes the measures for the OLAP cubes 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 |
CUBE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of a cube, such as UNITS_CUBE |
MEASURE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of a measure in the cube, such as SALES |
OVERRIDE_SOLVE_SPEC |
CLOB |
Syntax text for the measure's consistent solve specification that overrides that of its cube | |
MEASURE_TYPE |
VARCHAR2(7) |
Type of the OLAP measure:
|
|
EXPRESSION |
CLOB |
Expression that provides the values of the measure | |
DESCRIPTION |
NVARCHAR2(300) |
Description of the measure in the session language | |
DATA_TYPE |
VARCHAR2(106) |
Data type of the measure, such as NUMBER |
|
DATA_LENGTH |
NUMBER |
NOT NULL |
Length of a character data type |
DATA_PRECISION |
NUMBER |
Precision of a numeric data type | |
DATA_SCALE |
NUMBER |
Scale of a numeric data type |
See Also:
