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_MEASURE_FOLDER_CONTENTS

Object Details

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

OLAP Measure Folder Contents in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the OLAP Measure Folder Content
MEASURE_FOLDER_NAME	VARCHAR2	(128)	Yes	Name of the owning OLAP Measure Folder
CUBE_OWNER	VARCHAR2	(128)	Yes	Owner of the cube of the OLAP Measure Folder Content
CUBE_NAME	VARCHAR2	(128)	Yes	Name of the owning cube of the OLAP Measure Folder Content
MEASURE_NAME	VARCHAR2	(128)	Yes	Name of the owning measure of the OLAP Measure Folder Content
ORDER_NUM	NUMBER		Yes	Order number of the OLAP Measure Folder Content

Query Text

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


SELECT OWNER
,      MEASURE_FOLDER_NAME
,      CUBE_OWNER
,      CUBE_NAME
,      MEASURE_NAME
,      ORDER_NUM
FROM SYS.DBA_MEASURE_FOLDER_CONTENTS;

Dependencies

[top of page]

SYS.DBA_MEASURE_FOLDER_CONTENTS references the following:

SYS: OBJ$; OLAP_MEASURES$; OLAP_MEAS_FOLDER_CONTENTS$; USER$

SYS.DBA_MEASURE_FOLDER_CONTENTS is referenced by following:

PUBLIC: DBA_MEASURE_FOLDER_CONTENTS