VIEW: SYS.USER_CUBE_DIM_MODELS

Source

View Text - Preformatted

SELECT
  do.name DIMENSION_NAME,
  m.model_name MODEL_NAME,
  m.model_id MODEL_ID,
  d.description_value DESCRIPTION
FROM
  olap_models$ m,
  obj$ do,
  (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 = 16 --MODEL
        and (d.language = n.value
             or d.language like n.value || '\_%' escape '\')) d
WHERE
  m.owning_obj_type = 11 --DIMENSION
  AND m.owning_obj_id = do.obj#
  AND do.owner# = USERENV('SCHEMAID')
  AND m.model_id = d.owning_object_id(+)

View Text - HTML Formatted

SELECT DO.NAME DIMENSION_NAME
, M.MODEL_NAME MODEL_NAME
, M.MODEL_ID MODEL_ID
, D.DESCRIPTION_VALUE DESCRIPTION FROM OLAP_MODELS$ M
, OBJ$ DO
, (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 = 16 --MODEL
AND (D.LANGUAGE = N.VALUE OR D.LANGUAGE LIKE N.VALUE || '\_%' ESCAPE '\')) D WHERE M.OWNING_OBJ_TYPE = 11 --DIMENSION
AND M.OWNING_OBJ_ID = DO.OBJ#
AND DO.OWNER# = USERENV('SCHEMAID')
AND M.MODEL_ID = D.OWNING_OBJECT_ID(+)