[Home] [Help] [Dependency Information]
Object Name: | ALL_CUBE_HIERARCHIES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Hierarchies in the database accessible by the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the OLAP Hierarchy |
DIMENSION_NAME | VARCHAR2 | (128) | Yes | Name of owning dimension of the OLAP Hierarchy |
HIERARCHY_NAME | VARCHAR2 | (128) | Yes | Name of the OLAP Hierarchy |
HIERARCHY_ID | NUMBER | Yes | Dictionary Id of the OLAP Hierarchy | |
HIERARCHY_TYPE | VARCHAR2 | (5) | Type of the OLAP Hierarchy | |
DESCRIPTION | NVARCHAR2 | (600) | Long Description of the OLAP Hierarchy | |
IS_RAGGED | NUMBER | Indication of whether the OLAP Hierarchy is Ragged | ||
IS_SKIP_LEVEL | NUMBER | Indication of whether the OLAP Hierarchy is SkipLevel | ||
REFRESH_MVIEW_NAME | VARCHAR2 | (200) | Name of the refresh materialized view for the OLAP Hierarchy | |
CUSTOM_ORDER | CLOB | (4000) | Custom Order of the OLAP Hierarchy |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, DIMENSION_NAME
, HIERARCHY_NAME
, HIERARCHY_ID
, HIERARCHY_TYPE
, DESCRIPTION
, IS_RAGGED
, IS_SKIP_LEVEL
, REFRESH_MVIEW_NAME
, CUSTOM_ORDER
FROM SYS.ALL_CUBE_HIERARCHIES;
|
|
|