eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.USER_CUBE_DEPENDENCIES

Object Details

Object Name:	USER_CUBE_DEPENDENCIES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

OLAP metadata dependencies owned by the user in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
D_TOP_OBJ_NAME	VARCHAR2	(128)	Yes	Name of the top-level object of the dependent metadata object
D_SUB_OBJ_NAME1	VARCHAR2	(200)		Name of the first sub-object of the dependent metadata object
D_SUB_OBJ_NAME2	VARCHAR2	(200)		Name of the second sub-object of the dependent metadata object
D_SUB_OBJ_NAME3	VARCHAR2	(128)		Name of the third sub-object of the dependent metadata object
D_SUB_OBJ_NAME4	VARCHAR2	(128)		Name of the fourth sub-object of the dependent metadata object
D_OBJ_TYPE	VARCHAR2	(25)		Type of the dependent metadata object
P_OBJ_OWNER	VARCHAR2	(30)	Yes	Owner of the referenced metadata object
P_TOP_OBJ_NAME	VARCHAR2	(30)	Yes	Name of the top-level object of the referenced metadata object
P_SUB_OBJ_NAME1	VARCHAR2	(30)		Name of the first sub-object of the referenced metadata object
P_SUB_OBJ_NAME2	VARCHAR2	(30)		Name of the second sub-object of the referenced metadata object
P_SUB_OBJ_NAME3	VARCHAR2	(30)		Name of the third sub-object of the referenced metadata object
P_SUB_OBJ_NAME4	VARCHAR2	(30)		Name of the fourth sub-object of the referenced metadata object
P_OBJ_TYPE	VARCHAR2	(23)		Type of the referenced metadata object
DEPENDENCY_TYPE	VARCHAR2	(26)		Type of the dependency relationship

Query Text

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


SELECT D_TOP_OBJ_NAME
,      D_SUB_OBJ_NAME1
,      D_SUB_OBJ_NAME2
,      D_SUB_OBJ_NAME3
,      D_SUB_OBJ_NAME4
,      D_OBJ_TYPE
,      P_OBJ_OWNER
,      P_TOP_OBJ_NAME
,      P_SUB_OBJ_NAME1
,      P_SUB_OBJ_NAME2
,      P_SUB_OBJ_NAME3
,      P_SUB_OBJ_NAME4
,      P_OBJ_TYPE
,      DEPENDENCY_TYPE
FROM SYS.USER_CUBE_DEPENDENCIES;

Dependencies

[top of page]

SYS.USER_CUBE_DEPENDENCIES references the following:

SYS: DUAL; OBJ$; OLAP_ATTRIBUTES$; OLAP_CALCULATED_MEMBERS$; OLAP_CUBE_DIMENSIONS$; OLAP_DIMENSIONALITY$; OLAP_DIM_LEVELS$; OLAP_HIERARCHIES$; OLAP_HIER_LEVELS$; OLAP_IMPL_OPTIONS$; OLAP_MAPPINGS$; OLAP_MEASURES$; OLAP_METADATA_DEPENDENCIES$; OLAP_MODELS$; OLAP_MODEL_ASSIGNMENTS$; OLAP_MULTI_OPTIONS$

SYS.USER_CUBE_DEPENDENCIES is referenced by following:

PUBLIC: USER_CUBE_DEPENDENCIES