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


VIEW: OLAPSYS.ALL$OLAP_DIM_LEVEL_ATTR_MAPS

Object Details
Object Name: ALL$OLAP_DIM_LEVEL_ATTR_MAPS
Object Type: VIEW
Owner: OLAPSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes
DIMENSION_NAME VARCHAR2 (128) Yes
LEVEL_NAME VARCHAR2 (128)
ATTRIBUTE_NAME VARCHAR2 (240)
COLUMN_NAME VARCHAR2 (128) Yes
POSITION NUMBER

Query Text

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


SELECT OWNER
,      DIMENSION_NAME
,      LEVEL_NAME
,      ATTRIBUTE_NAME
,      COLUMN_NAME
,      POSITION
FROM OLAPSYS.ALL$OLAP_DIM_LEVEL_ATTR_MAPS;

Dependencies

[top of page]

OLAPSYS.ALL$OLAP_DIM_LEVEL_ATTR_MAPS references the following:

SchemaOLAPSYS
TableCWM$LEVEL
TableCWM$LEVELATTRIBUTE
PL/SQL PackageCWM$UTIL - show dependent code
SchemaPUBLIC
SynonymDBA_USERS
SynonymV$ENABLEDPRIVS
SchemaSYS
TableCOL$
TableDIMATTR$
TableDIMLEVEL$
TableOBJ$
OLAPSYS.ALL$OLAP_DIM_LEVEL_ATTR_MAPS is referenced by following:

SchemaPUBLIC
SynonymALL_OLAP_DIM_LEVEL_ATTR_MAPS