VIEW: SYS.DBA_CUBE_CALCULATED_MEMBERS

Source

View Text - Preformatted

SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  cm.member_name MEMBER_NAME,
  DECODE(cm.is_customaggregate, 1, 'YES', 0, 'NO') IS_CUSTOM_AGGREGATE,
  DECODE(cm.storage_type, 1, 'DYNAMIC', 2, 'PRECOMPUTE') STORAGE_TYPE,
  syn.syntax_clob EXPRESSION
FROM
  olap_calculated_members$ cm,
  obj$ o,
  user$ u,
  olap_syntax$ syn
WHERE
  cm.dim_obj#=o.obj#
  AND o.owner#=u.user#
  AND cm.member_id = syn.owner_id(+)
  AND syn.owner_type = 6 --CALC_MEMBER
  AND syn.ref_role=19 -- MEMBER_EXPRESSION_ROLE

View Text - HTML Formatted

SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, CM.MEMBER_NAME MEMBER_NAME
, DECODE(CM.IS_CUSTOMAGGREGATE
, 1
, 'YES'
, 0
, 'NO') IS_CUSTOM_AGGREGATE
, DECODE(CM.STORAGE_TYPE
, 1
, 'DYNAMIC'
, 2
, 'PRECOMPUTE') STORAGE_TYPE
, SYN.SYNTAX_CLOB EXPRESSION FROM OLAP_CALCULATED_MEMBERS$ CM
, OBJ$ O
, USER$ U
, OLAP_SYNTAX$ SYN WHERE CM.DIM_OBJ#=O.OBJ#
AND O.OWNER#=U.USER#
AND CM.MEMBER_ID = SYN.OWNER_ID(+)
AND SYN.OWNER_TYPE = 6 --CALC_MEMBER
AND SYN.REF_ROLE=19 -- MEMBER_EXPRESSION_ROLE