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.DBA_CUBE_CLASSIFICATIONS

Object Details

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

OLAP Object Classifications in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the OLAP Classification
OBJECT_NAME	VARCHAR2	(386)		Name of the OLAP Object that has the classification
OBJECT_TYPE	VARCHAR2	(18)		Type of the OLAP Object that has the classification
LANGUAGE	VARCHAR2	(80)	Yes	Language of the OLAP Classification
CLASSIFICATION	NVARCHAR2	(600)
ORDER_NUM	NUMBER			Order number of the OLAP Classification

Query Text

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


SELECT OWNER
,      OBJECT_NAME
,      OBJECT_TYPE
,      LANGUAGE
,      CLASSIFICATION
,      ORDER_NUM
FROM SYS.DBA_CUBE_CLASSIFICATIONS;

Dependencies

[top of page]

SYS.DBA_CUBE_CLASSIFICATIONS references the following:

SYS: OBJ$; OLAP_ATTRIBUTES$; OLAP_CALCULATED_MEMBERS$; OLAP_CUBES$; OLAP_DESCRIPTIONS$; OLAP_DIM_LEVELS$; OLAP_HIERARCHIES$; OLAP_HIER_LEVELS$; OLAP_MEASURES$; OLAP_MODELS$; OLAP_MODEL_ASSIGNMENTS$; USER$

SYS.DBA_CUBE_CLASSIFICATIONS is referenced by following:

PUBLIC: DBA_CUBE_CLASSIFICATIONS