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

Object Details

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

OLAP Descriptions in the database that are accessible to the user

[View Source]

Columns

Name	Datatype	Length	Comments
OWNER	VARCHAR2	(128)	Owner of the OLAP Description
OBJECT_NAME	VARCHAR2	(386)	NAME of the OLAP object that has the description
OBJECT_TYPE	VARCHAR2	(18)	Text value indicating the type of the OLAP object that has the description
DESCRIPTION_TYPE	VARCHAR2	(128)	Text value indicating the type the of OLAP Description
DESCRIPTION_VALUE	NVARCHAR2	(600)	Text of the OLAP Description
LANGUAGE	VARCHAR2	(80)	Language of the OLAP Description

Query Text

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


SELECT OWNER
,      OBJECT_NAME
,      OBJECT_TYPE
,      DESCRIPTION_TYPE
,      DESCRIPTION_VALUE
,      LANGUAGE
FROM SYS.ALL_CUBE_DESCRIPTIONS;

Dependencies

[top of page]

SYS.ALL_CUBE_DESCRIPTIONS references the following:

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

SYS.ALL_CUBE_DESCRIPTIONS is referenced by following:

PUBLIC: ALL_CUBE_DESCRIPTIONS