eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.USER_CUBE_SUB_PARTITION_LEVELS

Object Details

Object Name:	USER_CUBE_SUB_PARTITION_LEVELS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Comments
CUBE_NAME	VARCHAR2	(128)	Name of the OLAP Cube
SUB_PARTITION_LEVEL_NAME	VARCHAR2	(200)	Name of the secondary partition level of the OLAP Cube
PRECOMPUTE_PERCENT	NUMBER		Precompute percent of the secondary partition level of the OLAP Cube
PARTITION_DIMENSION_NAME	VARCHAR2	(128)	Name of the Cube Dimension for which there is a secondary partition level on the OLAP Cube
PARTITION_HIERARCHY_NAME	VARCHAR2	(128)	Name of the Hierarchy for which there is a secondary partition level on the OLAP Cube
PARTITION_LEVEL_NAME	VARCHAR2	(128)	Name of the HierarchyLevel for which there is a secondary partition level on the OLAP Cube
SUB_PARTITION_LEVEL_ORDER	NUMBER		Order number of the secondary partition level on the OLAP cube

Query Text

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


SELECT CUBE_NAME
,      SUB_PARTITION_LEVEL_NAME
,      PRECOMPUTE_PERCENT
,      PARTITION_DIMENSION_NAME
,      PARTITION_HIERARCHY_NAME
,      PARTITION_LEVEL_NAME
,      SUB_PARTITION_LEVEL_ORDER
FROM SYS.USER_CUBE_SUB_PARTITION_LEVELS;

Dependencies

[top of page]

SYS.USER_CUBE_SUB_PARTITION_LEVELS references the following:

SYS: OBJ$; OLAP_CUBES$; OLAP_DIM_LEVELS$; OLAP_HIERARCHIES$; OLAP_HIER_LEVELS$; OLAP_IMPL_OPTIONS$; OLAP_MULTI_OPTIONS$

SYS.USER_CUBE_SUB_PARTITION_LEVELS is referenced by following:

PUBLIC: USER_CUBE_SUB_PARTITION_LEVELS