DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.USER_CUBE_DIMNL_MAPPINGS

Object Details
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

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

SYS.USER_CUBE_DIMNL_MAPPINGS references the following:

SchemaSYS
TableOBJ$
TableOLAP_DIMENSIONALITY$
TableOLAP_DIM_LEVELS$
TableOLAP_HIERARCHIES$
TableOLAP_HIER_LEVELS$
TableOLAP_MAPPINGS$
TableOLAP_SYNTAX$
SYS.USER_CUBE_DIMNL_MAPPINGS is referenced by following:

SchemaPUBLIC
SynonymUSER_CUBE_DIMNL_MAPPINGS