VIEW: SYS.USER_CUBE_DIM_LEVELS

Source

View Text - Preformatted

SELECT
  o.name DIMENSION_NAME,
  dl.level_name LEVEL_NAME,
  dl.level_id LEVEL_ID,
  d.description_value DESCRIPTION
FROM
  obj$ o,
  olap_dim_levels$ dl,
  (select d.* from olap_descriptions$ d, nls_session_parameters n where
        n.parameter = 'NLS_LANGUAGE'
        and d.description_type = 'Description'
        and d.owning_object_type = 12 --DIM_LEVEL
        and (d.language = n.value
             or d.language like n.value || '\_%' escape '\')) d
WHERE
  o.obj#=dl.dim_obj# AND o.owner#=USERENV('SCHEMAID')
  AND d.owning_object_id(+)=dl.level_id

View Text - HTML Formatted

SELECT O.NAME DIMENSION_NAME
, DL.LEVEL_NAME LEVEL_NAME
, DL.LEVEL_ID LEVEL_ID
, D.DESCRIPTION_VALUE DESCRIPTION FROM OBJ$ O
, OLAP_DIM_LEVELS$ DL
, (SELECT D.*
FROM OLAP_DESCRIPTIONS$ D
, NLS_SESSION_PARAMETERS N WHERE N.PARAMETER = 'NLS_LANGUAGE'
AND D.DESCRIPTION_TYPE = 'DESCRIPTION'
AND D.OWNING_OBJECT_TYPE = 12 --DIM_LEVEL
AND (D.LANGUAGE = N.VALUE OR D.LANGUAGE LIKE N.VALUE || '\_%' ESCAPE '\')) D WHERE O.OBJ#=DL.DIM_OBJ#
AND O.OWNER#=USERENV('SCHEMAID')
AND D.OWNING_OBJECT_ID(+)=DL.LEVEL_ID