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

TABLE: OLAPSYS.CWM$CUBEDIMENSIONUSE

Object Details
Object Name: CWM$CUBEDIMENSIONUSE
Object Type: TABLE
Owner: OLAPSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CWM$CUBEDIMENSIONUSE_PK
  1. ColumnIRID
Indexes
Index Type Uniqueness Tablespace Column
CWM$CUBEDIMENSIONUSE_PK NORMAL UNIQUE TablespaceSYSAUX ColumnIRID
CWM$CUBEDIMENSIONUSE_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnABSTRACTDIMENSION_IRID
CWM$CUBEDIMENSIONUSE_IDX_1 NORMAL NONUNIQUE TablespaceSYSAUX ColumnDIMENSION_OWNER
ColumnDIMENSION_NAME
ColumnNAME
CWM$CUBEDIMENSIONUSE_IDX_2 NORMAL NONUNIQUE TablespaceSYSAUX ColumnCUBE_IRID
CWM$CUBEDIMENSIONUSE_IDX_3 NORMAL NONUNIQUE TablespaceSYSAUX ColumnCUBEDIMENSIONUSE_IRID
Foreign Keys
Table
Foreign Table Foreign Key Column
CWM$CUBEDIMENSIONUSE CWM$CUBEDIMENSIONUSE_FK TableCWM$CUBE CWM$CUBEDIMENSIONUSE CUBE_IRID
CWM$CUBEDIMENSIONUSE CWM$CUBEDIMENSIONUSE_FK_1 TableCWM$CUBEDIMENSIONUSE CWM$CUBEDIMENSIONUSE CUBEDIMENSIONUSE_IRID
TableCWM$CUBEDIMENSIONUSE CWM$CUBEDIMENSIONUSE_FK_1 CWM$CUBEDIMENSIONUSE CWM$CUBEDIMENSIONUSE CUBEDIMENSIONUSE_IRID
TableCWM$FACTLEVELUSE CWM$FACTLEVELUSE_FK_1 CWM$CUBEDIMENSIONUSE CWM$FACTLEVELUSE CUBEDIMENSIONUSE_IRID
TableCWM$MEASUREDIMENSIONUSE CWM$MEASUREDIMENSIONUSE_FK CWM$CUBEDIMENSIONUSE CWM$MEASUREDIMENSIONUSE CUBEDIMENSIONUSE_IRID
Columns
Name Datatype Length Mandatory Comments
IRID NUMBER (38) Yes
NAME VARCHAR2 (240)
SHORTDESCRIPTION VARCHAR2 (240)
DESCRIPTION VARCHAR2 (4000)
CREATEDBY VARCHAR2 (240)
CREATEDON DATE

LASTMODIFIEDBY VARCHAR2 (240)
LASTMODIFIEDON DATE

CUBEDIMENSIONUSE_IRID NUMBER (38)
HIERARCHY_IRID NUMBER (38)
CUBE_IRID NUMBER (38) Yes
ABSTRACTDIMENSION_IRID NUMBER (38) Yes
DATE_CHANGED DATE

DATE_CREATED DATE

IVID NUMBER (38)
NOTM NUMBER (38)
TYPES NUMBER (38)
USER_CHANGED_BY VARCHAR2 (30)
DIMENSION_OWNER VARCHAR2 (30) Yes
DIMENSION_NAME VARCHAR2 (30) Yes
CALC_HIERARCHY_NAME VARCHAR2 (30)
USER_CREATED_BY VARCHAR2 (30)
Query Text

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


SELECT IRID
,      NAME
,      SHORTDESCRIPTION
,      DESCRIPTION
,      CREATEDBY
,      CREATEDON
,      LASTMODIFIEDBY
,      LASTMODIFIEDON
,      CUBEDIMENSIONUSE_IRID
,      HIERARCHY_IRID
,      CUBE_IRID
,      ABSTRACTDIMENSION_IRID
,      DATE_CHANGED
,      DATE_CREATED
,      IVID
,      NOTM
,      TYPES
,      USER_CHANGED_BY
,      DIMENSION_OWNER
,      DIMENSION_NAME
,      CALC_HIERARCHY_NAME
,      USER_CREATED_BY
FROM OLAPSYS.CWM$CUBEDIMENSIONUSE;

Dependencies

[top of page]

OLAPSYS.CWM$CUBEDIMENSIONUSE does not reference any database object

OLAPSYS.CWM$CUBEDIMENSIONUSE is referenced by following:

SchemaOLAPSYS
ViewALL$OLAP1_CUBES
ViewALL$OLAP1_FACT_LEVEL_USES
ViewALL$OLAP2UCATALOG_ENTITY_USES
ViewALL$OLAP2UCUBE_DIM_USES
ViewALL$OLAP2UCUBE_MEASURES
ViewALL$OLAP2UCUBE_MEASURE_MAPS
ViewALL$OLAP2UCUBE_MEAS_DIM_USES
ViewALL$OLAP2UENTITY_DESC_USES
ViewALL$OLAP2UENTITY_EXT_PARMS
ViewALL$OLAP2UENTITY_PARAMETERS
ViewALL$OLAP_CUBE_DIM_USES
ViewALL$OLAP_CUBE_MEASURE_DIM_USES
ViewALL$OLAP_FACT_LEVEL_USES
Package BodyCWM$OLAP$CUBE - show dependent code
Package BodyCWM$OLAP$MEASURE - show dependent code
Package BodyCWM$UTIL - show dependent code
Package BodyCWM$UTILITY - show dependent code
ViewCWM2$MRTMPCWM1AGGORD
Package BodyCWM2_OLAP_CLASSIFY - show dependent code
Package BodyCWM2_OLAP_METADATA_REFRESH - show dependent code
Package BodyCWM2_OLAP_VALIDATE - show dependent code
ViewDBA$OLAP1_CUBES
ViewDBA$OLAP1_FACT_LEVEL_USES
ViewDBA$OLAP2UCATALOG_ENTITY_USES
ViewDBA$OLAP2UCUBE_DIM_USES
ViewDBA$OLAP2UCUBE_MEASURES
ViewDBA$OLAP2UCUBE_MEASURE_MAPS
ViewDBA$OLAP2UCUBE_MEAS_DIM_USES
ViewDBA$OLAP2UENTITY_DESC_USES
ViewDBA$OLAP2UENTITY_EXT_PARMS
ViewDBA$OLAP2UENTITY_PARAMETERS
ViewDBA$OLAP_CUBE_DIM_USES
ViewDBA$OLAP_CUBE_MEASURE_DIM_USES
ViewDBA$OLAP_FACT_LEVEL_USES
ViewEXPORT2UCATALOG_ENTITY_USES
ViewEXPORT2UENTITY_DESC_USES
ViewEXPORTOLAP1_CUBES