[Home] [Help] [Dependency Information]
Object Name: | ALL_CUBE_MEAS_MAPPINGS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Cube Measure Mappings in the database that are accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the OLAP Cube that contains the measure |
CUBE_NAME | VARCHAR2 | (128) | Yes | Name of the OLAP Cube that contains the measure |
CUBE_MAP_NAME | VARCHAR2 | (128) | Yes | Name of the map that contains the cube measure mapping |
MAP_NAME | VARCHAR2 | (128) | Yes | Name of the OLAP Cube Measure Mapping |
MAP_ID | NUMBER | Yes | Dictionary Id of the OLAP Cube Measure Mapping | |
MEASURE_NAME | VARCHAR2 | (128) | Yes | Name of the OLAP Cube Measure |
MEASURE_EXPRESSION | CLOB | (4000) | Expression of the OLAP Cube Measure Mapping |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, CUBE_NAME
, CUBE_MAP_NAME
, MAP_NAME
, MAP_ID
, MEASURE_NAME
, MEASURE_EXPRESSION
FROM SYS.ALL_CUBE_MEAS_MAPPINGS;
|
|
|