VIEW: SYS.USER_MEASURE_FOLDER_CONTENTS

Source

View Text - Preformatted

SELECT
  o.name MEASURE_FOLDER_NAME,
  cu.name CUBE_OWNER,
  co.name CUBE_NAME,
  m.measure_name MEASURE_NAME,
  mf.order_num ORDER_NUM
FROM
  olap_meas_folder_contents$ mf,
  obj$ o,
  olap_measures$ m,
  obj$ co,
  user$ cu
WHERE
  mf.measure_folder_obj#=o.obj#
  AND o.owner#=USERENV('SCHEMAID')
  AND mf.object_type = 2 -- MEASURE
  AND mf.object_id = m.measure_id
  AND m.cube_obj# = co.obj#
  AND co.owner# = cu.user#

View Text - HTML Formatted

SELECT O.NAME MEASURE_FOLDER_NAME
, CU.NAME CUBE_OWNER
, CO.NAME CUBE_NAME
, M.MEASURE_NAME MEASURE_NAME
, MF.ORDER_NUM ORDER_NUM FROM OLAP_MEAS_FOLDER_CONTENTS$ MF
, OBJ$ O
, OLAP_MEASURES$ M
, OBJ$ CO
, USER$ CU WHERE MF.MEASURE_FOLDER_OBJ#=O.OBJ#
AND O.OWNER#=USERENV('SCHEMAID')
AND MF.OBJECT_TYPE = 2 -- MEASURE
AND MF.OBJECT_ID = M.MEASURE_ID
AND M.CUBE_OBJ# = CO.OBJ#
AND CO.OWNER# = CU.USER#