[Home] [Help] [Dependency Information]

TABLE: OLAPSYS.CWM2$MEASURE

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: CWM2$MEASURE_PK

1. IRID

Unique Key: CWM2$MEASURE_NAME

1. CUBE_IRID
2. NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
CWM2$MEASURE_NAME	NORMAL	UNIQUE	SYSAUX	CUBE_IRID NAME
CWM2$MEASURE_PK	NORMAL	UNIQUE	SYSAUX	IRID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CWM2$MEASURE		CWM2$CUBE	CWM2$MEASURE CUBE_IRID
CWM2$MEASURETABLEMAP		CWM2$MEASURE	CWM2$MEASURETABLEMAP MEASURE_IRID

Columns

Query Text

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

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

Dependencies

[top of page]

OLAPSYS.CWM2$MEASURE does not reference any database object

OLAPSYS.CWM2$MEASURE is referenced by following:

OLAPSYS

ALL$AW_CUBE_AGG_MEASURES

ALL$AW_LOAD_CUBE_AGG_MEASURES

ALL$AW_LOAD_CUBE_MEAS

ALL$OLAP2UENTITY_PARAMETERS

ALL$OLAP2_CATALOG_ENTITY_USES

ALL$OLAP2_CUBE_MEASURES

ALL$OLAP2_CUBE_MEASURE_MAPS

ALL$OLAP2_CUBE_MEAS_DIM_USES

ALL$OLAP2_ENTITY_DESC_USES

CWM2$MEASUREDEL

CWM2$MEASUREUPD

CWM2_OLAP_CLASSIFY - show dependent code

CWM2_OLAP_MEASURE - 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_CATALOG_ENTITY_USES

DBA$OLAP2_CUBE_MEASURES

DBA$OLAP2_CUBE_MEASURE_MAPS

DBA$OLAP2_CUBE_MEAS_DIM_USES

DBA$OLAP2_ENTITY_DESC_USES

EXPORT2_CATALOG_ENTITY_USES

EXPORT2_ENTITY_DESC_USES