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

VIEW: SYS.CDB_CUBE_DIMNL_MAPPINGS

Object Details
Object Name: CDB_CUBE_DIMNL_MAPPINGS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

OLAP Cube Dimenisonality Mappings in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the OLAP Cube that contains the dimensionality
CUBE_NAME VARCHAR2 (30) 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 (30)
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
CON_ID NUMBER

container id
Query Text

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
,      CON_ID
FROM SYS.CDB_CUBE_DIMNL_MAPPINGS;

Dependencies

[top of page]

SYS.CDB_CUBE_DIMNL_MAPPINGS does not reference any database object

SYS.CDB_CUBE_DIMNL_MAPPINGS is referenced by following:

SchemaPUBLIC
SynonymCDB_CUBE_DIMNL_MAPPINGS