[Home] [Help] [Dependency Information]

TABLE: OLAPSYS.CWM$MEASUREDIMENSIONUSE

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: CWM$MEASUREDIMENSIONUSE_PK

1. IRID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CWM$MEASUREDIMENSIONUSE_PK	NORMAL	UNIQUE	SYSAUX	IRID
CWM$MEASUREDIMENSIONUSE_IDX	NORMAL	NONUNIQUE	SYSAUX	CUBEDIMENSIONUSE_IRID
CWM$MEASUREDIMENSIONUSE_IDX_1	NORMAL	NONUNIQUE	SYSAUX	MEASURE_IRID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CWM$MEASUREDIMENSIONUSE		CWM$CUBEDIMENSIONUSE	CWM$MEASUREDIMENSIONUSE CUBEDIMENSIONUSE_IRID
CWM$MEASUREDIMENSIONUSE		CWM$MEASURE	CWM$MEASUREDIMENSIONUSE MEASURE_IRID
CWM$FUNCTIONUSE		CWM$MEASUREDIMENSIONUSE	CWM$FUNCTIONUSE MEASUREDIMENSIONUSE_IRID

Columns

Query Text

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

SELECT IRID
,      MEASURE_IRID
,      CUBEDIMENSIONUSE_IRID
,      DATE_CHANGED
,      DATE_CREATED
,      IVID
,      NOTM
,      TYPES
,      USER_CHANGED_BY
,      USER_CREATED_BY
,      DIMENSION_OWNER
,      DIMENSION_NAME
FROM OLAPSYS.CWM$MEASUREDIMENSIONUSE;

Dependencies

[top of page]

OLAPSYS.CWM$MEASUREDIMENSIONUSE does not reference any database object

OLAPSYS.CWM$MEASUREDIMENSIONUSE is referenced by following:

OLAPSYS

ALL$OLAP2UCUBE_MEAS_DIM_USES

ALL$OLAP_CUBE_MEASURE_DIM_USES

ALL$OLAP_FUNCTION_USAGES

CWM$OLAP$MEASURE - show dependent code

CWM$UTIL - show dependent code

CWM2_OLAP_METADATA_REFRESH - show dependent code

DBA$OLAP2UCUBE_MEAS_DIM_USES

DBA$OLAP_CUBE_MEASURE_DIM_USES