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

VIEW: SYS.ALL_CUBE_DIM_MAPPINGS

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

OLAP Cube Dimension Mappings in the database that are accessible to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
Owner of the OLAP Cube Dimension
DIMENSION_NAME VARCHAR2 (128)
Name of the OLAP Cube Dimension that contains the mapping
HIERARCHY_NAME VARCHAR2 (128)
Name of the OLAP Cube Hierarchy that contains the mapping
LEVEL_NAME VARCHAR2 (128)
Name of the OLAP Cube Dimension Level that contains the mapping
MAP_NAME VARCHAR2 (128)
Name of the OLAP Cube Dimension Mapping
MAP_ID NUMBER

Dictionary Id of the OLAP Cube Dimension Mapping
MAPPED_DIMENSION_TYPE VARCHAR2 (17)
Text value indicating the type of the OLAP Dimension that contains the mapping
MAPPED_HIERARCHY_TYPE VARCHAR2 (5)
Text value indicating the type of the OLAP Hierarchy that contains the mapping
QUERY CLOB (4000)
Query of the OLAP Cube Dimension Mapping
KEY_EXPRESSION CLOB (4000)
Key expression of the OLAP Cube Dimension Mapping
FROM_CLAUSE CLOB (4000)
From clause of the OLAP Cube Dimension Mapping
WHERE_CLAUSE CLOB (4000)
Where clause of the OLAP Cube Dimension Mapping
JOIN_CONDITION CLOB (4000)
Join condition of the OLAP Cube Dimension Mapping
LEVEL_ID_EXPRESSION CLOB (4000)
Level ID expression of the OLAP Cube Dimension Mapping
PARENT_EXPRESSION CLOB (4000)
Parent expression of the OLAP Cube Dimension Mapping
PARENT_LEVEL_ID_EXPRESSION CLOB (4000)
Parent level ID expression of the OLAP Cube Dimension Mapping
LEVEL_EXPRESSION CLOB (4000)
Level expression of the OLAP Cube Dimension Mapping
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      DIMENSION_NAME
,      HIERARCHY_NAME
,      LEVEL_NAME
,      MAP_NAME
,      MAP_ID
,      MAPPED_DIMENSION_TYPE
,      MAPPED_HIERARCHY_TYPE
,      QUERY
,      KEY_EXPRESSION
,      FROM_CLAUSE
,      WHERE_CLAUSE
,      JOIN_CONDITION
,      LEVEL_ID_EXPRESSION
,      PARENT_EXPRESSION
,      PARENT_LEVEL_ID_EXPRESSION
,      LEVEL_EXPRESSION
FROM SYS.ALL_CUBE_DIM_MAPPINGS;

Dependencies

[top of page]

SYS.ALL_CUBE_DIM_MAPPINGS references the following:

SchemaSYS
TableOBJ$
TableOBJAUTH$
TableOLAP_DIM_LEVELS$
TableOLAP_HIERARCHIES$
TableOLAP_HIER_LEVELS$
TableOLAP_MAPPINGS$
TableOLAP_SYNTAX$
TableUSER$
SYS.ALL_CUBE_DIM_MAPPINGS is referenced by following:

SchemaPUBLIC
SynonymALL_CUBE_DIM_MAPPINGS