[Home] [Help] [Dependency Information]
Object Name: | CDB_CUBE_ATTR_MAPPINGS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Cube Attribute Mappings in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the OLAP Cube Attribute |
DIMENSION_NAME | VARCHAR2 | (30) | 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_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 | |
OWNER_MAP_NAME | VARCHAR2 | (128) | Yes | Name of 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 | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, DIMENSION_NAME
, ATTRIBUTE_NAME
, OWNER_MAP_DIMENSION_TYPE
, OWNER_MAP_HIERARCHY_NAME
, OWNER_MAP_LEVEL_NAME
, OWNER_MAP_NAME
, MAP_NAME
, MAP_ID
, ATTRIBUTE_EXPRESSION
, LANGUAGE
, CON_ID
FROM SYS.CDB_CUBE_ATTR_MAPPINGS;
SYS.CDB_CUBE_ATTR_MAPPINGS does not reference any database object
SYS.CDB_CUBE_ATTR_MAPPINGS is referenced by following:
|
|
|