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

VIEW: SYS.DBA_CUBE_DIM_LEVELS

Object Details
Object Name: DBA_CUBE_DIM_LEVELS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

OLAP Dimension Levels in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the OLAP Dimension Level
DIMENSION_NAME VARCHAR2 (128) Yes Name of the dimension which owns the OLAP Dimension Level
LEVEL_NAME VARCHAR2 (128) Yes Name of the OLAP Dimension Level
LEVEL_ID NUMBER
Yes Dictionary Id of the OLAP Dimension Level
DESCRIPTION NVARCHAR2 (600)
Long Description of the OLAP Dimension Level
Query Text

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


SELECT OWNER
,      DIMENSION_NAME
,      LEVEL_NAME
,      LEVEL_ID
,      DESCRIPTION
FROM SYS.DBA_CUBE_DIM_LEVELS;

Dependencies

[top of page]

SYS.DBA_CUBE_DIM_LEVELS references the following:

SchemaSYS
ViewNLS_SESSION_PARAMETERS
TableOBJ$
TableOLAP_DESCRIPTIONS$
TableOLAP_DIM_LEVELS$
TableUSER$
SYS.DBA_CUBE_DIM_LEVELS is referenced by following:

SchemaPUBLIC
SynonymDBA_CUBE_DIM_LEVELS