VIEW: SYS.USER_CUBE_MAPPINGS

Source

View Text - Preformatted

SELECT
  o.name CUBE_NAME,
  m.map_name MAP_NAME,
  m.map_id MAP_ID,
  s1.syntax_clob QUERY,
  s2.syntax_clob WHERE_CLAUSE,
  s3.syntax_clob FROM_CLAUSE,
  decode(i1.option_num_value, '1', 'Y', 'N') IS_SOLVED,
  i2.option_value AGGREGATION_METHOD
FROM
  olap_mappings$ m,
  obj$ o,
  olap_syntax$ s1,
  olap_syntax$ s2,
  olap_syntax$ s3,
  olap_impl_options$ i1,
  olap_impl_options$ i2
WHERE
  m.map_type = 22
  AND m.mapping_owner_id = 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(+) = 3
  AND m.map_id = s2.owner_id(+)
  AND m.map_type = s2.owner_type(+)
  AND s2.ref_role(+) = 21
  AND m.map_id = s3.owner_id(+)
  AND m.map_type = s3.owner_type(+)
  AND s3.ref_role(+) = 22
  AND m.map_id = i1.owning_objectid(+)
  AND m.map_type = i1.object_type(+)
  AND i1.option_type(+) = 11
  AND m.map_id = i2.owning_objectid(+)
  AND m.map_type = i2.object_type(+)
  AND i2.option_type(+) = 21

View Text - HTML Formatted

SELECT O.NAME CUBE_NAME
, M.MAP_NAME MAP_NAME
, M.MAP_ID MAP_ID
, S1.SYNTAX_CLOB QUERY
, S2.SYNTAX_CLOB WHERE_CLAUSE
, S3.SYNTAX_CLOB FROM_CLAUSE
, DECODE(I1.OPTION_NUM_VALUE
, '1'
, 'Y'
, 'N') IS_SOLVED
, I2.OPTION_VALUE AGGREGATION_METHOD FROM OLAP_MAPPINGS$ M
, OBJ$ O
, OLAP_SYNTAX$ S1
, OLAP_SYNTAX$ S2
, OLAP_SYNTAX$ S3
, OLAP_IMPL_OPTIONS$ I1
, OLAP_IMPL_OPTIONS$ I2 WHERE M.MAP_TYPE = 22
AND M.MAPPING_OWNER_ID = 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(+) = 3
AND M.MAP_ID = S2.OWNER_ID(+)
AND M.MAP_TYPE = S2.OWNER_TYPE(+)
AND S2.REF_ROLE(+) = 21
AND M.MAP_ID = S3.OWNER_ID(+)
AND M.MAP_TYPE = S3.OWNER_TYPE(+)
AND S3.REF_ROLE(+) = 22
AND M.MAP_ID = I1.OWNING_OBJECTID(+)
AND M.MAP_TYPE = I1.OBJECT_TYPE(+)
AND I1.OPTION_TYPE(+) = 11
AND M.MAP_ID = I2.OWNING_OBJECTID(+)
AND M.MAP_TYPE = I2.OBJECT_TYPE(+)
AND I2.OPTION_TYPE(+) = 21