[Home] [Help]
[Dependency Information]
TABLE: OLAPSYS.CWM2$HIERARCHY
Object Details
Object Name: | CWM2$HIERARCHY |
Object Type: | TABLE |
Owner: | OLAPSYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSAUX |
PCT Free: | 10 |
PCT Used: | |
Primary Key: CWM2$HIERARCHY_PK
- IRID
Unique Key: CWM2$HIERARCHY_NAME
- DIMENSION_IRID
- NAME
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
CWM2$HIERARCHY_NAME
|
NORMAL
|
UNIQUE
|
SYSAUX
|
DIMENSION_IRID
NAME
|
CWM2$HIERARCHY_PK
|
NORMAL
|
UNIQUE
|
SYSAUX
|
IRID
|
Foreign Keys
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
IRID |
NUMBER |
|
Yes |
|
DIMENSION_IRID |
NUMBER |
|
|
|
NAME |
VARCHAR2 |
(30) |
Yes |
|
SHORTDESCRIPTION |
VARCHAR2 |
(240) |
|
|
DESCRIPTION |
VARCHAR2 |
(2000) |
|
|
DISPLAYNAME |
VARCHAR2 |
(90) |
|
|
SOLVEDCODE |
VARCHAR2 |
(2) |
|
|
HIDDEN |
VARCHAR2 |
(2) |
|
|
ORIGIN |
VARCHAR2 |
(30) |
|
|
CREATEDDATE |
DATE |
|
|
|
UPDATEDDATE |
DATE |
|
|
|
LASTCHANGEUSER |
VARCHAR2 |
(30) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT IRID
, DIMENSION_IRID
, NAME
, SHORTDESCRIPTION
, DESCRIPTION
, DISPLAYNAME
, SOLVEDCODE
, HIDDEN
, ORIGIN
, CREATEDDATE
, UPDATEDDATE
, LASTCHANGEUSER
FROM OLAPSYS.CWM2$HIERARCHY;
Dependencies
[top of page]
OLAPSYS.CWM2$HIERARCHY does not reference any database object
OLAPSYS.CWM2$HIERARCHY is referenced by following:
-
OLAPSYS
-
ALL$OLAP2UENTITY_EXT_PARMS
-
ALL$OLAP2UENTITY_PARAMETERS
-
ALL$OLAP2ULISTDIMS
-
ALL$OLAP2_AGG_OPERATOR_USES
-
ALL$OLAP2_AGG_WEIGHTBY_USES
-
ALL$OLAP2_CUBE_DIM_USES
-
ALL$OLAP2_DIMENSIONS
-
ALL$OLAP2_DIM_HIERARCHIES
-
ALL$OLAP2_DIM_HIER_LEVEL_USES
-
ALL$OLAP2_DIM_LEVELS_KEYMAPS
-
ALL$OLAP2_DIM_LEVEL_ATTR_MAPS
-
ALL$OLAP2_ENTITY_DESC_USES
-
ALL$OLAP2_FACTTBLKEYMAPS
-
ALL$OLAP2_FACT_LEVEL_USES
-
ALL$OLAP2_FACT_TABLE_GID
-
ALL$OLAP2_HIER_CUSTOM_SORT
-
ALL$OLAP2_JOIN_KEY_COLUMN_USES
-
ALL$OLAP2_LEVEL_KEY_COL_USES
-
ALL$OLAP9I2_HIER_DIMENSIONS
-
CWM2$HIERARCHYUPD
-
CWM2_OLAP_CLASSIFY
- show dependent code
-
CWM2_OLAP_HIERARCHY
- show dependent code
-
CWM2_OLAP_METADATA_REFRESH
- show dependent code
-
CWM2_OLAP_TABLE_MAP
- show dependent code
-
CWM2_OLAP_UTILITY
- show dependent code
-
CWM2_OLAP_VALIDATE_METADATA
- show dependent code
-
DBA$OLAP2UENTITY_EXT_PARMS
-
DBA$OLAP2UENTITY_PARAMETERS
-
DBA$OLAP2ULISTDIMS
-
DBA$OLAP2_AGG_OPERATOR_USES
-
DBA$OLAP2_AGG_WEIGHTBY_USES
-
DBA$OLAP2_CUBE_DIM_USES
-
DBA$OLAP2_DIMENSIONS
-
DBA$OLAP2_DIM_HIERARCHIES
-
DBA$OLAP2_DIM_HIER_LEVEL_USES
-
DBA$OLAP2_DIM_LEVELS_KEYMAPS
-
DBA$OLAP2_DIM_LEVEL_ATTR_MAPS
-
DBA$OLAP2_ENTITY_DESC_USES
-
DBA$OLAP2_FACTTBLKEYMAPS
-
DBA$OLAP2_FACT_LEVEL_USES
-
DBA$OLAP2_FACT_TABLE_GID
-
DBA$OLAP2_HIER_CUSTOM_SORT
-
DBA$OLAP2_JOIN_KEY_COLUMN_USES
-
DBA$OLAP2_LEVEL_KEY_COL_USES
-
DBA$OLAP9I2_HIER_DIMENSIONS
-
EXPORT2_DIM_HIER_LEVEL_USES
-
EXPORT2_ENTITY_DESC_USES
-
EXPORT2_JOIN_KEY_COLUMN_USES
-
EXPORTOLAP2_DIMENSIONS
-
ODM$OLAP2_DIM_HIER_LEVEL_USES
-
ODM$OLAP2_FACT_LEVEL_USES
-
ODM$OLAP2_JOIN_KEY_COLUMN_USES
-
ODM$OLAP2_LEVEL_KEY_COL_USES