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_DIMENSIONS

Object Details

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

OLAP Cube Dimensions owned by the user in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_NAME	VARCHAR2	(128)	Yes	Name of the OLAP Cube Dimension
DIMENSION_ID	NUMBER		Yes	Dictionary Id of the OLAP Cube Dimension
DIMENSION_TYPE	VARCHAR2	(17)		Type of the OLAP Cube Dimension
AW_NAME	VARCHAR2	(128)		Name of the Analytic Workspace which owns the OLAP Cube Dimension
DEFAULT_HIERARCHY_NAME	VARCHAR2	(128)		Default Hierarchy name of the OLAP Cube Dimension
DESCRIPTION	NVARCHAR2	(600)		Long Description of the OLAP Cube Dimension
HIERARCHY_CONSISTENCY_RULE	VARCHAR2	(200)		Hierarchy consistency rule of the OLAP Cube Dimension
ADD_UNIQUE_KEY_PREFIX	VARCHAR2	(3)		Add_Unique_Key_Prefix flag of the OLAP Cube Dimension
CUSTOM_ORDER	CLOB	(4000)		Custom Order of the OLAP Cube Dimension

Query Text

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


SELECT DIMENSION_NAME
,      DIMENSION_ID
,      DIMENSION_TYPE
,      AW_NAME
,      DEFAULT_HIERARCHY_NAME
,      DESCRIPTION
,      HIERARCHY_CONSISTENCY_RULE
,      ADD_UNIQUE_KEY_PREFIX
,      CUSTOM_ORDER
FROM SYS.USER_CUBE_DIMENSIONS;

Dependencies

[top of page]

SYS.USER_CUBE_DIMENSIONS references the following:

SYS: AW$; NLS_SESSION_PARAMETERS; OBJ$; OLAP_CUBE_DIMENSIONS$; OLAP_DESCRIPTIONS$; OLAP_HIERARCHIES$; OLAP_IMPL_OPTIONS$; OLAP_SYNTAX$

SYS.USER_CUBE_DIMENSIONS is referenced by following:

PUBLIC: USER_CUBE_DIMENSIONS