[Home] [Help] [Dependency Information]
Object Name: | ALL_CUBE_DIMNL_MAPPINGS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Cube Dimenisonality 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 dimensionality |
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 OWNER
, 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.ALL_CUBE_DIMNL_MAPPINGS;
|
|
|