[Home] [Help] [Dependency Information]

TABLE: OLAPSYS.CWM2$DIMENSIONATTRIBUTE

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: CWM2$DIMENSIONATTRIBUTE_PK

1. IRID

Unique Key: CWM2$DIMENSIONATTRIBUTE_NAME

1. DIMENSION_IRID
2. NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
CWM2$DIMENSIONATTRIBUTE_NAME	NORMAL	UNIQUE	SYSAUX	DIMENSION_IRID NAME
CWM2$DIMENSIONATTRIBUTE_PK	NORMAL	UNIQUE	SYSAUX	IRID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CWM2$DIMENSIONATTRIBUTE		CWM2$DIMENSION	CWM2$DIMENSIONATTRIBUTE DIMENSION_IRID
CWM2$LEVELATTRIBUTE		CWM2$DIMENSIONATTRIBUTE	CWM2$LEVELATTRIBUTE DIMATTR_IRID

Columns

Query Text

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

SELECT IRID
,      DIMENSION_IRID
,      NAME
,      SHORTDESCRIPTION
,      DESCRIPTION
,      DISPLAYNAME
,      CREATEDDATE
,      UPDATEDDATE
,      LASTCHANGEUSER
FROM OLAPSYS.CWM2$DIMENSIONATTRIBUTE;

Dependencies

[top of page]

OLAPSYS.CWM2$DIMENSIONATTRIBUTE does not reference any database object

OLAPSYS.CWM2$DIMENSIONATTRIBUTE is referenced by following:

OLAPSYS

ALL$OLAP2UENTITY_PARAMETERS

ALL$OLAP2_DIM_ATTRIBUTES

ALL$OLAP2_DIM_ATTR_USES

ALL$OLAP2_DIM_LEVEL_ATTR_MAPS

ALL$OLAP2_ENTITY_DESC_USES

CWM2$DIMENSIONATTRIBUTEUPD

CWM2_OLAP_CLASSIFY - show dependent code

CWM2_OLAP_DIMENSION_ATTRIBUTE - show dependent code

CWM2_OLAP_METADATA_REFRESH - show dependent code

CWM2_OLAP_UTILITY - show dependent code

CWM2_OLAP_VALIDATE_METADATA - show dependent code

DBA$OLAP2UENTITY_PARAMETERS

DBA$OLAP2_DIM_ATTRIBUTES

DBA$OLAP2_DIM_ATTR_USES

DBA$OLAP2_DIM_LEVEL_ATTR_MAPS

DBA$OLAP2_ENTITY_DESC_USES

EXPORT2_ENTITY_DESC_USES