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

VIEW: SYS.USER_CUBE_DIM_LEVELS

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

OLAP Dimension Levels owned by the user in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
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 DIMENSION_NAME
,      LEVEL_NAME
,      LEVEL_ID
,      DESCRIPTION
FROM SYS.USER_CUBE_DIM_LEVELS;

Dependencies

[top of page]

SYS.USER_CUBE_DIM_LEVELS references the following:

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

SchemaPUBLIC
SynonymUSER_CUBE_DIM_LEVELS