VIEW: SYS.USER_CUBE_MEAS_MAPPINGS

Source

View Text - Preformatted

SELECT
  o.name CUBE_NAME,
  owner_map.map_name CUBE_MAP_NAME,
  m.map_name MAP_NAME,
  m.map_id MAP_ID,
  meas.measure_name MEASURE_NAME,
  s1.syntax_clob MEASURE_EXPRESSION
FROM
  olap_mappings$ m,
  olap_mappings$ owner_map,
  obj$ o,
  olap_measures$ meas,
  olap_syntax$ s1
WHERE
  m.map_type = 24
  AND m.mapped_object_id = meas.measure_id
  AND m.mapping_owner_id = owner_map.map_id
  AND meas.cube_obj# = o.obj#
  AND o.owner#=USERENV('SCHEMAID')
  AND m.map_id = s1.owner_id(+)
  AND m.map_type = s1.owner_type(+)
  AND s1.ref_role(+) = 1

View Text - HTML Formatted

SELECT O.NAME CUBE_NAME
, OWNER_MAP.MAP_NAME CUBE_MAP_NAME
, M.MAP_NAME MAP_NAME
, M.MAP_ID MAP_ID
, MEAS.MEASURE_NAME MEASURE_NAME
, S1.SYNTAX_CLOB MEASURE_EXPRESSION FROM OLAP_MAPPINGS$ M
, OLAP_MAPPINGS$ OWNER_MAP
, OBJ$ O
, OLAP_MEASURES$ MEAS
, OLAP_SYNTAX$ S1 WHERE M.MAP_TYPE = 24
AND M.MAPPED_OBJECT_ID = MEAS.MEASURE_ID
AND M.MAPPING_OWNER_ID = OWNER_MAP.MAP_ID
AND MEAS.CUBE_OBJ# = O.OBJ#
AND O.OWNER#=USERENV('SCHEMAID')
AND M.MAP_ID = S1.OWNER_ID(+)
AND M.MAP_TYPE = S1.OWNER_TYPE(+)
AND S1.REF_ROLE(+) = 1