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

VIEW: SYS.USER_CUBE_ATTR_MAPPINGS

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

OLAP Cube Attribute Mappings owned by the user in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
DIMENSION_NAME VARCHAR2 (128) Yes Name of the Cube Dimension of the Cube Attribute
ATTRIBUTE_NAME VARCHAR2 (128) Yes Name of the Cube Attribute
OWNER_MAP_DIMENSION_TYPE VARCHAR2 (17)
Text value indicating the type of the Cube Dimenension that owns the map that contains the Cube Attribute Mapping
OWNER_MAP_NAME VARCHAR2 (128) Yes Name of the map that contains the Cube Attribute Mapping
OWNER_MAP_HIERARCHY_NAME VARCHAR2 (128)
Name of the Hierarchy of the Cube Dimension that owns the map that contains the Cube Attribute Mapping
OWNER_MAP_LEVEL_NAME VARCHAR2 (128)
Name of the Level of the Cube Dimension or Cube Hierarchy that owns the map that contains the Cube Attribute Mapping
MAP_NAME VARCHAR2 (128) Yes Name of the Cube Attribute Mapping
MAP_ID NUMBER
Yes Dictionary Id of the Cube Attribute Mapping
ATTRIBUTE_EXPRESSION CLOB (4000)
Expression of the Cube Attribute Mapping
LANGUAGE VARCHAR2 (200)
Language of the Cube Attribute Mapping
Query Text

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


SELECT DIMENSION_NAME
,      ATTRIBUTE_NAME
,      OWNER_MAP_DIMENSION_TYPE
,      OWNER_MAP_NAME
,      OWNER_MAP_HIERARCHY_NAME
,      OWNER_MAP_LEVEL_NAME
,      MAP_NAME
,      MAP_ID
,      ATTRIBUTE_EXPRESSION
,      LANGUAGE
FROM SYS.USER_CUBE_ATTR_MAPPINGS;

Dependencies

[top of page]

SYS.USER_CUBE_ATTR_MAPPINGS references the following:

SchemaSYS
TableOBJ$
TableOLAP_ATTRIBUTES$
TableOLAP_DIM_LEVELS$
TableOLAP_HIERARCHIES$
TableOLAP_HIER_LEVELS$
TableOLAP_IMPL_OPTIONS$
TableOLAP_MAPPINGS$
TableOLAP_SYNTAX$
SYS.USER_CUBE_ATTR_MAPPINGS is referenced by following:

SchemaPUBLIC
SynonymUSER_CUBE_ATTR_MAPPINGS