[Home] [Help] [Dependency Information]

TABLE: OLAPSYS.CWM$FACTTABLEMAP

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: CWM$FACTTABLEMAP_PK

1. IRID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CWM$FACTTABLEMAP_PK	NORMAL	UNIQUE	SYSAUX	IRID
CWM$FACTTABLEMAP_IDX	NORMAL	NONUNIQUE	SYSAUX	MAPCONTAINER_IRID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CWM$FACTTABLEMAP		CWM$CUBE	CWM$FACTTABLEMAP MAPCONTAINER_IRID
CWM$FACTUSE		CWM$FACTTABLEMAP	CWM$FACTUSE OPERATION_IRID_1
CWM$FACTUSE		CWM$FACTTABLEMAP	CWM$FACTUSE OPERATION_IRID

Columns

Query Text

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

SELECT IRID
,      NAME
,      SHORTDESCRIPTION
,      DESCRIPTION
,      CREATEDBY
,      CREATEDON
,      LASTMODIFIEDBY
,      LASTMODIFIEDON
,      MAPCONTAINER_IRID
,      DATE_CHANGED
,      DATE_CREATED
,      IVID
,      MAPCONTAINER_FK_SEQ
,      NOTM
,      TYPES
,      USER_CHANGED_BY
,      USER_CREATED_BY
FROM OLAPSYS.CWM$FACTTABLEMAP;

Dependencies

[top of page]

OLAPSYS.CWM$FACTTABLEMAP does not reference any database object

OLAPSYS.CWM$FACTTABLEMAP is referenced by following:

OLAPSYS

ALL$OLAP1_FACT_LEVEL_USES

ALL$OLAP_FACT_LEVEL_USES

CWM$OLAP$CUBE - show dependent code

CWM$OLAP$MEASURE - show dependent code

CWM$UTIL - show dependent code

CWM$UTILITY - show dependent code

DBA$OLAP1_FACT_LEVEL_USES

DBA$OLAP_FACT_LEVEL_USES