VIEW: SYS.DBA_CUBE_BUILD_PROCESSES

Source

View Text - Preformatted

SELECT
  u.name OWNER,
  o.name BUILD_PROCESS_NAME,
  ia.obj# BUILD_PROCESS_ID,
  syn.syntax_clob BUILD_PROCESS,
  d.description_value DESCRIPTION
FROM
  olap_cube_build_processes$ ia,
  obj$ o,
  user$ u,
  olap_syntax$ syn,
  (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 = 8 --BUILD_PROCESS
        and (d.language = n.value
             or d.language like n.value || '\_%' escape '\')) d
WHERE
  ia.obj# = o.obj#
  AND o.owner# = u.user#
  AND ia.obj# = d.owning_object_id(+)
  AND syn.owner_id(+)=ia.obj#
  AND syn.owner_type(+)=8
  AND syn.ref_role(+)=13 -- build process

View Text - HTML Formatted

SELECT U.NAME OWNER
, O.NAME BUILD_PROCESS_NAME
, IA.OBJ# BUILD_PROCESS_ID
, SYN.SYNTAX_CLOB BUILD_PROCESS
, D.DESCRIPTION_VALUE DESCRIPTION FROM OLAP_CUBE_BUILD_PROCESSES$ IA
, OBJ$ O
, USER$ U
, OLAP_SYNTAX$ SYN
, (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 = 8 --BUILD_PROCESS
AND (D.LANGUAGE = N.VALUE OR D.LANGUAGE LIKE N.VALUE || '\_%' ESCAPE '\')) D WHERE IA.OBJ# = O.OBJ#
AND O.OWNER# = U.USER#
AND IA.OBJ# = D.OWNING_OBJECT_ID(+)
AND SYN.OWNER_ID(+)=IA.OBJ#
AND SYN.OWNER_TYPE(+)=8
AND SYN.REF_ROLE(+)=13 -- BUILD PROCESS