VIEW: OLAPSYS.ALL$OLAP_FUNCTION_USAGES

Source

View Text - Preformatted

SELECT
  u.irid function_usage_id
, f.name function_name
FROM
  cwm$function f
, cwm$functionuse u
, cwm$measuredimensionuse mdu
, cwm$measure msr
WHERE f.irid = u.function_irid
AND u.measuredimensionuse_irid = mdu.irid
AND mdu.measure_irid = msr.irid
AND (    cwm$util.fact_table_visible(msr.itemcontainer_irid) = 'Y'
     OR EXISTS /* SELECT ANY TABLE */
       (SELECT null FROM v$enabledprivs
        WHERE priv_number = -47))
UNION ALL SELECT
  u.irid function_usage_id
, f.name function_name
FROM
  cwm$function f
, cwm$functionuse u
WHERE f.irid = u.function_irid
AND u.measuredimensionuse_irid IS NULL
WITH READ ONLY

View Text - HTML Formatted

SELECT U.IRID FUNCTION_USAGE_ID
, F.NAME FUNCTION_NAME FROM CWM$FUNCTION F
, CWM$FUNCTIONUSE U
, CWM$MEASUREDIMENSIONUSE MDU
, CWM$MEASURE MSR WHERE F.IRID = U.FUNCTION_IRID AND U.MEASUREDIMENSIONUSE_IRID = MDU.IRID AND MDU.MEASURE_IRID = MSR.IRID AND ( CWM$UTIL.FACT_TABLE_VISIBLE(MSR.ITEMCONTAINER_IRID) = 'Y' OR EXISTS /* SELECT ANY TABLE */ (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER = -47)) UNION ALL SELECT U.IRID FUNCTION_USAGE_ID
, F.NAME FUNCTION_NAME FROM CWM$FUNCTION F
, CWM$FUNCTIONUSE U WHERE F.IRID = U.FUNCTION_IRID AND U.MEASUREDIMENSIONUSE_IRID IS NULL WITH READ ONLY