DBA Data[Home] [Help] [Dependency Information]

TABLE: OLAPSYS.CWM2$FACTKEYDIMHIERLVLMAP

Object Details
Object Name: CWM2$FACTKEYDIMHIERLVLMAP
Object Type: TABLE
Owner: OLAPSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CWM2$FACTKEYDIMHIERLVLMAP_PK
  1. ColumnIRID
Indexes
Index Type Uniqueness Tablespace Column
CWM2$FACTKEYDIMHIERLVLMAP_PK NORMAL UNIQUE TablespaceSYSAUX ColumnIRID
CWM2$FACTKEYDIMHIERLVLMAP_IF NORMAL NONUNIQUE TablespaceSYSAUX ColumnFACTKEYDIMHIER_IRID
Foreign Keys
Table
Foreign Table Foreign Key Column
CWM2$FACTKEYDIMHIERLVLMAP CWM2$FACTKEYDHLM_FKDHM_FK TableCWM2$FACTKEYDIMHIERMAP CWM2$FACTKEYDIMHIERLVLMAP FACTKEYDIMHIER_IRID
CWM2$FACTKEYDIMHIERLVLMAP CWM2$FACTKEYD_H_L_MAP_HIER_FK TableCWM2$HIERARCHY CWM2$FACTKEYDIMHIERLVLMAP HIERARCHY_IRID
CWM2$FACTKEYDIMHIERLVLMAP CWM2$FACTKEYD_H_L_MAP_LVL_FK TableCWM2$LEVEL CWM2$FACTKEYDIMHIERLVLMAP LEVEL_IRID
Columns
Name Datatype Length Mandatory Comments
IRID NUMBER
Yes
FACTKEYDIMHIER_IRID NUMBER

LEVEL_IRID NUMBER

HIERARCHY_IRID NUMBER

COLUMNNAME_ID NUMBER

POSITION NUMBER

CREATEDDATE DATE

UPDATEDDATE DATE

LASTCHANGEUSER VARCHAR2 (30)
Query Text

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


SELECT IRID
,      FACTKEYDIMHIER_IRID
,      LEVEL_IRID
,      HIERARCHY_IRID
,      COLUMNNAME_ID
,      POSITION
,      CREATEDDATE
,      UPDATEDDATE
,      LASTCHANGEUSER
FROM OLAPSYS.CWM2$FACTKEYDIMHIERLVLMAP;

Dependencies

[top of page]

OLAPSYS.CWM2$FACTKEYDIMHIERLVLMAP does not reference any database object

OLAPSYS.CWM2$FACTKEYDIMHIERLVLMAP is referenced by following:

SchemaOLAPSYS
ViewALL$OLAP2_FACTTBLKEYMAPS
ViewALL$OLAP2_FACT_LEVEL_USES
TriggerCWM2$FACTKEYDIMHIERLVLMAPUPD
Package BodyCWM2_OLAP_METADATA_REFRESH - show dependent code
Package BodyCWM2_OLAP_TABLE_MAP - show dependent code
Package BodyCWM2_OLAP_VALIDATE_METADATA - show dependent code
ViewDBA$OLAP2_FACTTBLKEYMAPS
ViewDBA$OLAP2_FACT_LEVEL_USES
ViewODM$OLAP2_FACT_LEVEL_USES