[Home] [Help] [Dependency Information]

TABLE: OLAPSYS.CWM$HIERARCHY

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: CWM$HIERARCHY_PK

1. IRID

Unique Key: CWM$HIERARCHY_UK

1. NAME
2. DIMENSION_IRID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CWM$HIERARCHY_PK	NORMAL	UNIQUE	SYSAUX	IRID
CWM$HIERARCHY_UK	NORMAL	UNIQUE	SYSAUX	NAME DIMENSION_IRID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CWM$HIERARCHY		CWM$DIMENSION	CWM$HIERARCHY DIMENSION_IRID

Columns

Query Text

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

SELECT IRID
,      NAME
,      SHORTDESCRIPTION
,      DESCRIPTION
,      CREATEDBY
,      CREATEDON
,      LASTMODIFIEDBY
,      LASTMODIFIEDON
,      DISPLAYNAME
,      DIMENSION_IRID_1
,      DIMENSION_IRID
,      DATE_CHANGED
,      DATE_CREATED
,      IVID
,      NOTM
,      TYPES
,      USER_CHANGED_BY
,      USER_CREATED_BY
FROM OLAPSYS.CWM$HIERARCHY;

Dependencies

[top of page]

OLAPSYS.CWM$HIERARCHY does not reference any database object

OLAPSYS.CWM$HIERARCHY is referenced by following:

OLAPSYS

ALL$OLAP2UDIM_HIERARCHIES

ALL$OLAP2UDIM_HIER_LEVEL_USES

ALL$OLAP2UENTITY_EXT_PARMS

ALL$OLAP2ULISTDIMS

ALL$OLAP_DIM_HIERARCHIES

CWM$OLAP$HIERARCHY - show dependent code

CWM$UTIL - show dependent code

CWM$UTILITY - show dependent code

CWM1_OLAP_VALIDATE_METADATA - show dependent code

CWM2_OLAP_CLASSIFY - show dependent code

CWM2_OLAP_METADATA_REFRESH - show dependent code

CWM2_OLAP_TABLE_MAP - show dependent code

DBA$OLAP2UDIM_HIERARCHIES

DBA$OLAP2UDIM_HIER_LEVEL_USES

DBA$OLAP2UENTITY_EXT_PARMS

DBA$OLAP2ULISTDIMS

DBA$OLAP_DIM_HIERARCHIES

EXPORT2UDIM_HIER_LEVEL_USES

ODM$OLAP2UDIM_HIER_LEVEL_USES