[Home] [Help] [Dependency Information]
Object Name: | USER_CUBE_DIMNL_MAPPINGS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Cube Dimenisonality Mappings owned by the user in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUBE_NAME | VARCHAR2 | (128) | Yes | Name of the OLAP Cube that contains the dimensionality |
CUBE_MAP_NAME | VARCHAR2 | (128) | Yes | Name of the OLAP Cube Map that contains the dimensionality mapping |
MAP_NAME | VARCHAR2 | (128) | Yes | Name of the OLAP Cube Dimensionality Mapping |
MAP_ID | NUMBER | Yes | Dictionary Id of the OLAP Cube Dimensionality Mapping | |
MAPPED_DIMENSION_NAME | VARCHAR2 | (128) | Name of the mapped dimension of the OLAP Cube Dimensionality | |
MAPPED_HIERARCHY_NAME | VARCHAR2 | (128) | Name of the mapped hierarchy of the OLAP Cube Dimensionality | |
MAPPED_LEVEL_NAME | VARCHAR2 | (128) | Name of the mapped dimension level of the OLAP Cube Dimensionality | |
MAPPED_DIMENSION_TYPE | VARCHAR2 | (17) | Text value indicating the type of the mapped dimension object | |
JOIN_CONDITION | CLOB | (4000) | Join condition of the OLAP Cube Dimensionality | |
LEVEL_ID_EXPRESSION | CLOB | (4000) | Level ID expression of the OLAP Cube Dimensionality | |
DIMENSIONALITY_EXPRESSION | CLOB | (4000) | Dimensionality expression of the OLAP Cube Dimensionality |
Cut, paste (and edit) the following text to query this object:
SELECT CUBE_NAME
, CUBE_MAP_NAME
, MAP_NAME
, MAP_ID
, MAPPED_DIMENSION_NAME
, MAPPED_HIERARCHY_NAME
, MAPPED_LEVEL_NAME
, MAPPED_DIMENSION_TYPE
, JOIN_CONDITION
, LEVEL_ID_EXPRESSION
, DIMENSIONALITY_EXPRESSION
FROM SYS.USER_CUBE_DIMNL_MAPPINGS;
|
|
|