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

VIEW: SYS.DBA_CUBE_HIER_LEVELS

Object Details
Object Name: DBA_CUBE_HIER_LEVELS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

OLAP Hierarchy Levels in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the OLAP Hierarchy Level
DIMENSION_NAME VARCHAR2 (128) Yes Name of the owning Dimension of the OLAP Hierarchy Level
HIERARCHY_NAME VARCHAR2 (128) Yes Name of the owning Hierarchy of the OLAP Hierarchy Level
LEVEL_NAME VARCHAR2 (128) Yes Name of the OLAP Dimension Level
HIERARCHY_LEVEL_ID NUMBER
Yes Dictionary Id of the OLAP Hierarchy Level
ORDER_NUM NUMBER
Yes Order number of the OLAP Hierarchy Level within the hierarchy
DESCRIPTION NVARCHAR2 (600)
Long Description of the OLAP Hierarchy Level
Query Text

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


SELECT OWNER
,      DIMENSION_NAME
,      HIERARCHY_NAME
,      LEVEL_NAME
,      HIERARCHY_LEVEL_ID
,      ORDER_NUM
,      DESCRIPTION
FROM SYS.DBA_CUBE_HIER_LEVELS;

Dependencies

[top of page]

SYS.DBA_CUBE_HIER_LEVELS references the following:

SchemaSYS
ViewNLS_SESSION_PARAMETERS
TableOBJ$
TableOLAP_DESCRIPTIONS$
TableOLAP_DIM_LEVELS$
TableOLAP_HIERARCHIES$
TableOLAP_HIER_LEVELS$
TableUSER$
SYS.DBA_CUBE_HIER_LEVELS is referenced by following:

SchemaPUBLIC
SynonymDBA_CUBE_HIER_LEVELS